--
-- Host: localhost    Database: nightlaw
-- ------------------------------------------------------


--
-- Table structure for table `allhousing`
--

CREATE TABLE `allhousing` (
  `id` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `ownername` varchar(50) NOT NULL,
  `owned` tinyint(4) NOT NULL,
  `price` int(11) NOT NULL,
  `originalprice` int(11) NOT NULL,
  `resalepercent` int(11) NOT NULL,
  `entry` longtext NOT NULL,
  `garage` longtext NOT NULL,
  `furniture` longtext NOT NULL,
  `shell` varchar(50) NOT NULL,
  `shells` longtext NOT NULL,
  `housekeys` longtext NOT NULL,
  `wardrobe` longtext NOT NULL,
  `inventorylocation` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `allhousing`
--

INSERT INTO `allhousing` VALUES (1,1,'wcode',1,522000,79000,2,'','','','Casa #1','','','',''),(2,3,'fivemw',1,522000,79000,2,'','','','Casa #2','','','','');

--
-- Table structure for table `aplicatii_staff_history`
--

CREATE TABLE `aplicatii_staff_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `nume` varchar(255) NOT NULL,
  `motiv` text NOT NULL,
  `grad` varchar(50) NOT NULL,
  `status` enum('acceptat','respins') NOT NULL,
  `processed_by` bigint(20) unsigned NOT NULL,
  `processed_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `aplicatii_staff_history`
--


--
-- Table structure for table `aplicatiistaff`
--

CREATE TABLE `aplicatiistaff` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `nume` varchar(255) NOT NULL,
  `motiv` text NOT NULL,
  `grad` varchar(50) NOT NULL,
  `status` enum('in_asteptare','acceptat','respins') DEFAULT 'in_asteptare',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `aplicatiistaff`
--


--
-- Table structure for table `carmileages`
--

CREATE TABLE `carmileages` (
  `plate` varchar(50) NOT NULL,
  `mileage` float NOT NULL DEFAULT 0,
  PRIMARY KEY (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `carmileages`
--

INSERT INTO `carmileages` VALUES (' ADMIN  ',52.4318),('60JFQ469',0.147299);

--
-- Table structure for table `debux_battlepass`
--

CREATE TABLE `debux_battlepass` (
  `identifier` varchar(46) NOT NULL,
  `myXP` int(11) NOT NULL DEFAULT 0,
  `myBP` longtext DEFAULT 'default',
  `myTASK` longtext DEFAULT '[]',
  `myAWAY` longtext DEFAULT '[]'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `debux_battlepass`
--

INSERT INTO `debux_battlepass` VALUES ('2',0,'default','{\"d\":0,\"e\":0,\"b\":0,\"c\":0,\"a\":0}','{\"standart\":{\"2\":\"noreceived\",\"3\":\"noreceived\",\"4\":\"noreceived\",\"1\":\"noreceived\"},\"premium\":{\"2\":\"noreceived\",\"3\":\"noreceived\",\"4\":\"noreceived\",\"1\":\"noreceived\"}}');

--
-- Table structure for table `debux_references`
--

CREATE TABLE `debux_references` (
  `identifier` longtext DEFAULT NULL,
  `references_code` varchar(250) DEFAULT '0',
  `references_totalinvite` varchar(250) DEFAULT '0',
  `references_claim` varchar(250) DEFAULT '0',
  `references_login` varchar(250) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `debux_references`
--

INSERT INTO `debux_references` VALUES ('1','1','0','0','0'),('2','2','0','0','1'),('3','3','0','0','0'),('4','4','0','0','0');

--
-- Table structure for table `factions`
--

CREATE TABLE `factions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `type` text DEFAULT NULL,
  `slots` int(255) NOT NULL DEFAULT 10,
  `ranks` text DEFAULT NULL,
  `budget` int(255) NOT NULL DEFAULT 0,
  `color` varchar(255) NOT NULL DEFAULT '31',
  `home` text DEFAULT NULL,
  `chest` text DEFAULT NULL,
  `application` tinyint(1) NOT NULL DEFAULT 0,
  `MinLevel` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `factions`
--

INSERT INTO `factions` VALUES (1,'Politie','Lege',50,'[{\"payday\":5000,\"rank\":\"Cadet\"},{\"payday\":5500,\"rank\":\"Agent\"},{\"payday\":6000,\"rank\":\"Agent Sef\"},{\"payday\":6500,\"rank\":\"Agent Sef Principal\"},{\"payday\":7000,\"rank\":\"Sub-Inspector\"},{\"payday\":7500,\"rank\":\"Inspector\"},{\"payday\":8000,\"rank\":\"Inspector Sef\"},{\"payday\":8500,\"rank\":\"Sub-Comisar\"},{\"payday\":9000,\"rank\":\"Comisar\"},{\"payday\":9500,\"rank\":\"Comisar Sef\"},{\"payday\":10000,\"rank\":\"Chestor\"},{\"payday\":10500,\"rank\":\"Chestor Sef\"},{\"payday\":11000,\"rank\":\"Chestor General\"}]',1454,'1','[217.6615447998047,-615.2703247070313,41.3780517578125]',NULL,1,1),(2,'Smurd','Lege',50,'[{\"rank\":\"Paramedic\",\"payday\":5000},{\"rank\":\"Medic\",\"payday\":6000},{\"rank\":\"Doctor\",\"payday\":7000},{\"rank\":\"Medic Militar\",\"payday\":8000},{\"rank\":\"Doctor Generalist\",\"payday\":9000},{\"rank\":\"Director Adjunct\",\"payday\":10000},{\"rank\":\"Director\",\"payday\":11000}]',0,'1','[348.6461486816406,-549.4945068359375,28.7406005859375]',NULL,1,1),(3,'Sindicat','Mafie',25,'[{\"payday\":0,\"rank\":\"Sageata\"},{\"payday\":0,\"rank\":\"Membru\"},{\"payday\":0,\"rank\":\"Co-Lider\"},{\"payday\":0,\"rank\":\"Lider\"}]',12164,'1','[217.6615447998047,-615.2703247070313,41.3780517578125]',NULL,1,1),(4,'Marabunta Grande','Mafie',15,'[{\"payday\":0,\"rank\":\"Sageata\"},{\"payday\":0,\"rank\":\"Membru\"},{\"payday\":0,\"rank\":\"Co-Lider\"},{\"payday\":0,\"rank\":\"Lider\"}]',0,'1','[217.6615447998047,-615.2703247070313,41.3780517578125]',NULL,1,1),(5,'Crips Gang','Mafie',15,'[{\"rank\":\"Membru\",\"payday\":0},{\"rank\":\"Co-Lider\",\"payday\":0},{\"rank\":\"Lider\",\"payday\":0}]',0,'3','[-595.4901123046875,530.0966796875,107.74951171875]','{\"pos\":[-596.03076171875,546.936279296875,111.220458984375],\"weight\":1000}',1,1),(6,'Mercenari','Mafie',75,'[{\"rank\":\"Membru\",\"payday\":0},{\"rank\":\"Co-Lider\",\"payday\":0},{\"rank\":\"Lider\",\"payday\":0}]',0,'56','[-2349.428466796875,3266.861572265625,32.801513671875]','{\"weight\":1000000,\"pos\":[-2345.90771484375,3231.86376953125,34.958251953125]}',1,1);

--
-- Table structure for table `garages`
--

CREATE TABLE `garages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `x` float DEFAULT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `gtype` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `garages`
--

INSERT INTO `garages` VALUES (1,361.134,-950.832,29.3992,'Personal'),(2,470.819,-580.532,28.4997,'Personal'),(3,-209.6,-1168.43,23.044,'Personal'),(4,-132.43,-1167.05,23.7696,'Personal'),(5,-1087.43,-316.962,37.6666,'Personal'),(6,-1018.78,-2731.76,13.6722,'Personal'),(7,-725.229,-915.391,19.0139,'Personal'),(8,-1607.98,-813.992,10.0279,'Personal'),(9,750.069,-877.288,25.0622,'Personal'),(10,934.417,-0.96686,78.764,'Personal'),(11,77.624,6365.57,31.2297,'Personal'),(12,2089.24,4767.65,41.1631,'Personal'),(13,1628.04,3560.16,35.2326,'Personal'),(14,1850.88,3674.19,33.7752,'Personal'),(15,1834.18,2541.46,45.8805,'Personal'),(16,378.569,293.458,103.201,'Personal'),(17,135.333,-690.9,42.029,'Personal'),(18,102.439,-1397.91,29.2713,'Personal'),(19,34.5146,-1727.73,29.303,'Personal'),(20,-1508.65,1485.76,116.58,'Personal'),(21,454.636,-1019.84,28.3452,'police'),(22,293.381,-607.893,43.3376,'emergency'),(23,449.601,-981.254,43.6918,'Police Helicopters'),(25,-2964.21,462.727,15.2183,'Personal'),(26,2964.22,2747.63,43.328,'Personal'),(27,666.222,676.855,128.911,'Personal'),(28,683.473,670.896,128.911,'Personal'),(29,698.756,664.821,128.911,'Personal'),(30,599.061,604.814,128.911,'Personal'),(32,351.934,-587.911,74.164,'EMS Helicopters'),(33,-724.778,-1444.17,5.00052,'Elicoptere'),(34,4454.16,-4507.35,4.18496,'Elicoptere'),(35,-1542.03,889.06,181.531,'Marabunta'),(36,-1564.3,846.829,183.641,'Marabunta Helipad'),(37,-3259.38,839.963,2.91649,'Sindicat Helipad'),(38,-3200.65,814.971,8.92708,'Sindicat'),(39,-1531.22,890.908,181.899,'Personal'),(40,-586.39,528.151,107.738,'Crips'),(41,-580.031,517.184,106.392,'Personal');

--
-- Table structure for table `hy_cargojob`
--

CREATE TABLE `hy_cargojob` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `experience` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `hy_cargojob`
--

INSERT INTO `hy_cargojob` VALUES (17,'2',3),(18,'1',0),(19,'3',0),(20,'9',0),(21,'12',0),(22,'4',0);

--
-- Table structure for table `markets`
--

CREATE TABLE `markets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `x` float DEFAULT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `type` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `markets`
--

INSERT INTO `markets` VALUES (1,-707.397,-914.087,19.2156,'24/7'),(2,-48.095,-1757.54,29.421,'24/7'),(3,25.7242,-1346.3,29.497,'24/7'),(4,1135.59,-981.871,46.4158,'24/7'),(5,1163.48,-323.242,69.2051,'24/7'),(6,-1222.99,-907.21,12.3264,'24/7'),(7,374.06,326.966,103.566,'24/7'),(8,352.231,284.621,91.19,'Club'),(9,2556.84,382.141,108.623,'24/7'),(10,-2967.87,391.032,15.0433,'24/7'),(11,-3040.05,585.525,7.90893,'24/7'),(12,-3242.13,1001.23,12.8307,'24/7'),(13,-656.994,-857.627,24.5031,'Electronice'),(14,302.657,-589.558,43.2698,'Farmacie'),(15,430.137,-799.274,29.4911,'Genti'),(16,1605.92,3572.12,39.1107,'Mafia Market'),(17,-1820.39,792.584,138.11,'24/7'),(18,128.686,-1286.1,29.2799,'Club'),(19,-715.946,-145.914,37.4152,'Genti'),(20,-1834.57,-1191.87,14.3088,'Club'),(21,1698.47,4924.19,42.0637,'24/7'),(22,1729.27,6415.19,35.0372,'24/7'),(23,-830.04,-1074.77,11.3281,'Genti'),(24,-164.773,-312.22,39.7333,'Genti');

--
-- Table structure for table `mdt_caziere`
--

CREATE TABLE `mdt_caziere` (
  `id` int(11) NOT NULL,
  `players` text DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `target` int(11) DEFAULT NULL,
  `createdAt` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `house` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mdt_caziere`
--


--
-- Table structure for table `mdt_codes`
--

CREATE TABLE `mdt_codes` (
  `id` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mdt_codes`
--


--
-- Table structure for table `mdt_evidences`
--

CREATE TABLE `mdt_evidences` (
  `id` int(11) NOT NULL,
  `players` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `createdAt` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mdt_evidences`
--


--
-- Table structure for table `mdt_fines`
--

CREATE TABLE `mdt_fines` (
  `id` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mdt_fines`
--


--
-- Table structure for table `mdt_incidents`
--

CREATE TABLE `mdt_incidents` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `players` text DEFAULT NULL,
  `cops` text DEFAULT NULL,
  `createdAt` varchar(255) DEFAULT NULL,
  `vehicles` text DEFAULT NULL,
  `evidences` text DEFAULT NULL,
  `fines` text DEFAULT NULL,
  `jail` text DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mdt_incidents`
--


--
-- Table structure for table `mdt_jail`
--

CREATE TABLE `mdt_jail` (
  `name` varchar(255) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mdt_jail`
--

INSERT INTO `mdt_jail` VALUES ('Test',12,1);

--
-- Table structure for table `panel_update_ratings`
--

CREATE TABLE `panel_update_ratings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `update_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `rating` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `panel_update_ratings`
--

INSERT INTO `panel_update_ratings` VALUES (1,1,2,5,'2025-12-29 20:49:29','2025-12-29 20:49:29'),(2,2,2,5,'2025-12-30 14:46:58','2025-12-30 14:46:58'),(3,3,2,5,'2025-12-30 14:49:33','2025-12-30 14:49:33');

--
-- Table structure for table `panel_updates`
--

CREATE TABLE `panel_updates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text NOT NULL DEFAULT 'No description',
  `author` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `category` varchar(64) NOT NULL DEFAULT 'server',
  `update_version` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `panel_updates`
--


--
-- Table structure for table `phone_backups`
--

CREATE TABLE `phone_backups` (
  `id` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_backups_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_backups`
--

INSERT INTO `phone_backups` VALUES ('3','0707845491'),('2','0771819196');

--
-- Table structure for table `phone_clock_alarms`
--

CREATE TABLE `phone_clock_alarms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `hours` int(2) NOT NULL DEFAULT 0,
  `minutes` int(2) NOT NULL DEFAULT 0,
  `label` varchar(50) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_clock_alarms_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_clock_alarms`
--


--
-- Table structure for table `phone_contacts`
--

CREATE TABLE `phone_contacts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `number` varchar(255) NOT NULL,
  `name` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `phone_contacts`
--


--
-- Table structure for table `phone_crypto`
--

CREATE TABLE `phone_crypto` (
  `id` varchar(100) NOT NULL,
  `coin` varchar(15) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `invested` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`coin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_crypto`
--

INSERT INTO `phone_crypto` VALUES ('license:152cdaa6245e1de95c4489b61f312f15e1b9fd4a','bitcoin',0.01088389095865296,1000),('license:152cdaa6245e1de95c4489b61f312f15e1b9fd4a','ripple',0,-34);

--
-- Table structure for table `phone_darkchat_accounts`
--

CREATE TABLE `phone_darkchat_accounts` (
  `phone_number` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_darkchat_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_darkchat_accounts`
--


--
-- Table structure for table `phone_darkchat_channels`
--

CREATE TABLE `phone_darkchat_channels` (
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_darkchat_channels`
--


--
-- Table structure for table `phone_darkchat_members`
--

CREATE TABLE `phone_darkchat_members` (
  `channel_name` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  PRIMARY KEY (`channel_name`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_darkchat_members_ibfk_1` FOREIGN KEY (`channel_name`) REFERENCES `phone_darkchat_channels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_darkchat_members_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_darkchat_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_darkchat_members`
--


--
-- Table structure for table `phone_darkchat_messages`
--

CREATE TABLE `phone_darkchat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` varchar(50) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel` (`channel`),
  KEY `sender` (`sender`),
  CONSTRAINT `phone_darkchat_messages_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `phone_darkchat_channels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_darkchat_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_darkchat_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_darkchat_messages`
--


--
-- Table structure for table `phone_instagram_accounts`
--

CREATE TABLE `phone_instagram_accounts` (
  `display_name` varchar(30) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  `profile_image` varchar(500) DEFAULT NULL,
  `bio` varchar(100) DEFAULT NULL,
  `post_count` int(11) NOT NULL DEFAULT 0,
  `story_count` int(11) NOT NULL DEFAULT 0,
  `follower_count` int(11) NOT NULL DEFAULT 0,
  `following_count` int(11) NOT NULL DEFAULT 0,
  `phone_number` varchar(15) NOT NULL,
  `private` tinyint(1) DEFAULT 0,
  `verified` tinyint(1) DEFAULT 0,
  `date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_instagram_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_accounts`
--


--
-- Table structure for table `phone_instagram_comments`
--

CREATE TABLE `phone_instagram_comments` (
  `id` varchar(10) NOT NULL,
  `post_id` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL DEFAULT '',
  `like_count` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `phone_instagram_posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_instagram_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_comments`
--


--
-- Table structure for table `phone_instagram_follow_requests`
--

CREATE TABLE `phone_instagram_follow_requests` (
  `requester` varchar(20) NOT NULL,
  `requestee` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`requester`,`requestee`),
  KEY `requestee` (`requestee`),
  CONSTRAINT `phone_instagram_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_follow_requests`
--


--
-- Table structure for table `phone_instagram_follows`
--

CREATE TABLE `phone_instagram_follows` (
  `followed` varchar(20) NOT NULL,
  `follower` varchar(20) NOT NULL,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_instagram_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_follows`
--


--
-- Table structure for table `phone_instagram_likes`
--

CREATE TABLE `phone_instagram_likes` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `is_comment` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_likes`
--


--
-- Table structure for table `phone_instagram_messages`
--

CREATE TABLE `phone_instagram_messages` (
  `id` varchar(10) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `recipient` varchar(20) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_instagram_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_messages`
--


--
-- Table structure for table `phone_instagram_notifications`
--

CREATE TABLE `phone_instagram_notifications` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `from` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `post_id` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  CONSTRAINT `phone_instagram_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_notifications`
--


--
-- Table structure for table `phone_instagram_posts`
--

CREATE TABLE `phone_instagram_posts` (
  `id` varchar(10) NOT NULL,
  `media` text DEFAULT NULL,
  `caption` varchar(500) NOT NULL DEFAULT '',
  `location` varchar(50) DEFAULT NULL,
  `like_count` int(11) NOT NULL DEFAULT 0,
  `comment_count` int(11) NOT NULL DEFAULT 0,
  `username` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_posts_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_posts`
--


--
-- Table structure for table `phone_instagram_stories`
--

CREATE TABLE `phone_instagram_stories` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `image` varchar(500) NOT NULL,
  `metadata` longtext DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_stories_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_stories`
--


--
-- Table structure for table `phone_instagram_stories_views`
--

CREATE TABLE `phone_instagram_stories_views` (
  `story_id` varchar(50) NOT NULL,
  `viewer` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`story_id`,`viewer`),
  KEY `viewer` (`viewer`),
  CONSTRAINT `phone_instagram_stories_views_ibfk_1` FOREIGN KEY (`story_id`) REFERENCES `phone_instagram_stories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_instagram_stories_views_ibfk_2` FOREIGN KEY (`viewer`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_instagram_stories_views`
--


--
-- Table structure for table `phone_last_phone`
--

CREATE TABLE `phone_last_phone` (
  `id` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_last_phone_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_last_phone`
--


--
-- Table structure for table `phone_logged_in_accounts`
--

CREATE TABLE `phone_logged_in_accounts` (
  `phone_number` varchar(15) NOT NULL,
  `app` varchar(50) NOT NULL,
  `username` varchar(100) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`phone_number`,`app`,`username`),
  CONSTRAINT `phone_logged_in_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_logged_in_accounts`
--

INSERT INTO `phone_logged_in_accounts` VALUES ('0771819196','Mail','notandreizz@nightlaw.ro',1);

--
-- Table structure for table `phone_mail_accounts`
--

CREATE TABLE `phone_mail_accounts` (
  `address` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_mail_accounts`
--

INSERT INTO `phone_mail_accounts` VALUES ('notandreizz@nightlaw.ro','$2a$11$r/Ot7YUOWFx4zHFRDBKffulsx7WpbAHUtY.zEkxin5WYRP1wbf4GG');

--
-- Table structure for table `phone_mail_deleted`
--

CREATE TABLE `phone_mail_deleted` (
  `message_id` int(10) unsigned NOT NULL,
  `address` varchar(100) NOT NULL,
  PRIMARY KEY (`message_id`,`address`),
  KEY `address` (`address`),
  CONSTRAINT `phone_mail_deleted_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `phone_mail_messages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_mail_deleted_ibfk_2` FOREIGN KEY (`address`) REFERENCES `phone_mail_accounts` (`address`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_mail_deleted`
--


--
-- Table structure for table `phone_mail_messages`
--

CREATE TABLE `phone_mail_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `recipient` varchar(100) NOT NULL,
  `sender` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `attachments` longtext DEFAULT NULL,
  `actions` longtext DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_recipient` (`recipient`),
  KEY `idx_sender` (`sender`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_mail_messages`
--


--
-- Table structure for table `phone_maps_locations`
--

CREATE TABLE `phone_maps_locations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `name` varchar(50) NOT NULL,
  `x_pos` float NOT NULL,
  `y_pos` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_maps_locations_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_maps_locations`
--


--
-- Table structure for table `phone_marketplace_posts`
--

CREATE TABLE `phone_marketplace_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `attachments` text DEFAULT NULL,
  `price` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_marketplace_posts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_marketplace_posts`
--


--
-- Table structure for table `phone_message_channels`
--

CREATE TABLE `phone_message_channels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_group` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(50) DEFAULT NULL,
  `last_message` varchar(50) NOT NULL DEFAULT '',
  `last_message_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_message_channels`
--

INSERT INTO `phone_message_channels` VALUES (1,0,NULL,'','2026-01-05 18:17:11'),(2,0,NULL,'','2026-01-05 18:17:33'),(3,0,NULL,'','2026-01-05 18:23:58'),(4,0,NULL,'','2026-01-05 18:27:47'),(5,0,NULL,'aa','2026-01-05 18:34:51'),(6,0,NULL,'<!SENT-LOCATION-X=-1827.1Y=-1194.35!>','2026-01-06 21:48:04'),(7,0,NULL,'sall','2026-01-06 16:05:01'),(8,0,NULL,'aa','2026-03-07 12:47:14');

--
-- Table structure for table `phone_message_members`
--

CREATE TABLE `phone_message_members` (
  `channel_id` int(11) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `is_owner` tinyint(1) NOT NULL DEFAULT 0,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  `unread` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`channel_id`,`phone_number`),
  KEY `idx_members_phone_number` (`phone_number`),
  CONSTRAINT `phone_message_members_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_message_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_message_members`
--

INSERT INTO `phone_message_members` VALUES (5,'5208269970',0,0,0),(6,'5208269970',0,0,1),(6,'6029739340',0,0,1),(7,'5201043324',0,0,1),(7,'5208269970',0,0,0),(8,'0707845491',0,0,3),(8,'0771819196',0,0,0);

--
-- Table structure for table `phone_message_messages`
--

CREATE TABLE `phone_message_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) NOT NULL,
  `sender` varchar(15) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_message_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_message_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_message_messages`
--

INSERT INTO `phone_message_messages` VALUES (1,5,'5208269970','aa',NULL,'2026-01-05 18:34:51'),(3,6,'5208269970','<!SENT-LOCATION-X=321.74Y=-271.01!>',NULL,'2026-01-06 10:45:39'),(4,7,'5208269970','sall',NULL,'2026-01-06 16:05:01'),(5,6,'5208269970','aa',NULL,'2026-01-06 21:41:33'),(6,6,'5208269970','nn',NULL,'2026-01-06 21:43:31'),(7,6,'5208269970','🥹',NULL,'2026-01-06 21:43:37'),(8,6,'6029739340','😀',NULL,'2026-01-06 21:43:58'),(9,6,'5208269970','☝️',NULL,'2026-01-06 21:44:11'),(10,6,'5208269970','<!SENT-LOCATION-X=-1827.1Y=-1194.35!>',NULL,'2026-01-06 21:48:04'),(11,8,'0771819196','<!SENT-PAYMENT-20000!>',NULL,'2026-03-07 12:12:51'),(12,8,'0771819196','aa','[]','2026-03-07 12:47:14'),(13,8,'0771819196','aa','[]','2026-03-07 12:53:48');

--
-- Table structure for table `phone_messages`
--

CREATE TABLE `phone_messages` (
  `A_I` int(11) NOT NULL,
  `id` int(255) NOT NULL,
  `involved` text DEFAULT NULL,
  `messages` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `phone_messages`
--


--
-- Table structure for table `phone_music_playlists`
--

CREATE TABLE `phone_music_playlists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `name` varchar(50) NOT NULL,
  `cover` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_music_playlists_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_music_playlists`
--


--
-- Table structure for table `phone_music_saved_playlists`
--

CREATE TABLE `phone_music_saved_playlists` (
  `playlist_id` int(10) unsigned NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`playlist_id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_music_saved_playlists_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_music_saved_playlists_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_music_saved_playlists`
--


--
-- Table structure for table `phone_music_songs`
--

CREATE TABLE `phone_music_songs` (
  `song_id` varchar(100) NOT NULL,
  `playlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`song_id`,`playlist_id`),
  KEY `playlist_id` (`playlist_id`),
  CONSTRAINT `phone_music_songs_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_music_songs`
--


--
-- Table structure for table `phone_notes`
--

CREATE TABLE `phone_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` longtext DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_notes_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_notes`
--


--
-- Table structure for table `phone_notifications`
--

CREATE TABLE `phone_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `app` varchar(50) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `content` varchar(500) DEFAULT NULL,
  `thumbnail` varchar(500) DEFAULT NULL,
  `avatar` varchar(500) DEFAULT NULL,
  `show_avatar` tinyint(1) DEFAULT 0,
  `custom_data` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_notifications_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_notifications`
--

INSERT INTO `phone_notifications` VALUES (59,'0707845491','Messages','0771819196','<!SENT-PAYMENT-20000!>',NULL,NULL,1,NULL,'2026-03-07 12:12:51'),(60,'0707845491','Wallet','0771819196','$20 000',NULL,NULL,NULL,NULL,'2026-03-07 12:12:51'),(63,'0707845491','Messages','0771819196','aa',NULL,NULL,1,NULL,'2026-03-07 12:47:14'),(64,'0707845491','Messages','0771819196','aa',NULL,NULL,1,NULL,'2026-03-07 12:53:48');

--
-- Table structure for table `phone_phone_blocked_numbers`
--

CREATE TABLE `phone_phone_blocked_numbers` (
  `phone_number` varchar(15) NOT NULL,
  `blocked_number` varchar(15) NOT NULL,
  PRIMARY KEY (`phone_number`,`blocked_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_phone_blocked_numbers`
--


--
-- Table structure for table `phone_phone_calls`
--

CREATE TABLE `phone_phone_calls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caller` varchar(15) NOT NULL,
  `callee` varchar(15) NOT NULL,
  `duration` int(11) NOT NULL DEFAULT 0,
  `answered` tinyint(1) DEFAULT 0,
  `hide_caller_id` tinyint(1) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_calls_missed` (`callee`,`answered`),
  KEY `idx_calls_callee_id` (`callee`),
  KEY `idx_calls_caller_id` (`caller`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_phone_calls`
--

INSERT INTO `phone_phone_calls` VALUES (1,'5208269970','6029739340',0,0,0,'2026-01-05 22:38:03'),(2,'5208269970','6029739340',0,0,0,'2026-01-05 22:38:28'),(3,'5208269970','6029739340',0,0,0,'2026-01-06 10:45:25'),(4,'5208269970','6029739340',0,0,0,'2026-01-06 12:01:47'),(5,'5208269970','6029739340',0,0,0,'2026-01-06 12:02:00'),(6,'5208269970','6029739340',0,0,0,'2026-01-06 12:31:31'),(7,'5208269970','6029739340',0,0,0,'2026-01-06 12:55:43'),(8,'5201043324','5208269970',8,1,0,'2026-01-06 13:45:44'),(9,'5208269970','5201043324',0,0,0,'2026-01-06 16:05:39'),(10,'5208269970','5201043324',0,0,0,'2026-01-06 16:05:46'),(11,'5208269970','5201043324',0,0,0,'2026-01-06 16:06:00'),(12,'5208269970','6029739340',3,0,0,'2026-01-06 21:22:05'),(13,'5208269970','6029739340',8,1,0,'2026-01-06 21:31:51'),(14,'6029739340','112',0,0,0,'2026-01-06 21:32:14'),(15,'0778649855','112',0,0,0,'2026-02-16 13:19:35');

--
-- Table structure for table `phone_phone_contacts`
--

CREATE TABLE `phone_phone_contacts` (
  `contact_phone_number` varchar(15) NOT NULL,
  `firstname` varchar(50) NOT NULL DEFAULT '',
  `lastname` varchar(50) NOT NULL DEFAULT '',
  `profile_image` varchar(500) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `favourite` tinyint(1) DEFAULT 0,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`contact_phone_number`,`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_phone_contacts`
--

INSERT INTO `phone_phone_contacts` VALUES ('0707845491','Eric','Dev',NULL,NULL,NULL,0,'0771819196'),('5201043324','edi\'s Phone','',NULL,NULL,NULL,0,'5208269970'),('5208269970','NotAndreiZz','',NULL,NULL,NULL,0,'5201043324'),('6029739340','Boss','Mountain',NULL,NULL,NULL,0,'5208269970');

--
-- Table structure for table `phone_phone_voicemail`
--

CREATE TABLE `phone_phone_voicemail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caller` varchar(15) NOT NULL,
  `callee` varchar(15) NOT NULL,
  `url` varchar(500) NOT NULL,
  `duration` int(11) NOT NULL,
  `hide_caller_id` tinyint(1) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_phone_voicemail`
--


--
-- Table structure for table `phone_phones`
--

CREATE TABLE `phone_phones` (
  `id` varchar(100) NOT NULL,
  `owner_id` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `pin` varchar(4) DEFAULT NULL,
  `face_id` varchar(100) DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `is_setup` tinyint(1) DEFAULT 0,
  `assigned` tinyint(1) DEFAULT 0,
  `battery` int(11) NOT NULL DEFAULT 100,
  `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_phones`
--

INSERT INTO `phone_phones` VALUES ('2','2','0771819196','NotAndreiZz\'s Phone','2007','2','{\"notifications\":[],\"locale\":\"ro\",\"phone\":{\"showCallerId\":true},\"airplaneMode\":false,\"apps\":[[\"Phone\",\"Messages\",\"Camera\",\"Photos\"],[\"Settings\",\"AppStore\",\"Clock\",\"Mail\",\"Weather\",\"Wallet\",\"Garage\",\"Home\",\"Maps\",\"Notes\",\"Calculator\",\"VoiceMemo\",\"Music\",\"Services\"]],\"time\":{\"twelveHourClock\":false},\"storage\":{\"total\":128000000,\"used\":8580363.559999999},\"version\":\"2.3.4\",\"security\":{\"pinCode\":true,\"faceId\":true},\"weather\":{\"celcius\":false},\"display\":{\"size\":0.7,\"theme\":\"dark\",\"automatic\":false,\"brightness\":1},\"latestVersion\":\"2.5.4\",\"wallpaper\":{\"background\":\"cloud8\",\"blur\":false},\"sound\":{\"volume\":0.5,\"silent\":false,\"ringtone\":\"default\",\"callVolume\":0.5,\"texttone\":\"default\"},\"streamerMode\":false,\"lockscreen\":{\"fontStyle\":1,\"layout\":1,\"color\":\"gradient\"},\"doNotDisturb\":false,\"name\":\"NotAndreiZz\'s Phone\"}',1,0,100,'2026-03-08 15:51:57'),('3','3','0707845491','lib_e21c\'s Phone',NULL,NULL,'{\"locale\":\"en\",\"latestVersion\":\"2.5.4\",\"phone\":{\"showCallerId\":true},\"storage\":{\"total\":128000000,\"used\":8576331},\"version\":\"2.3.4\",\"apps\":[[\"Phone\",\"Messages\",\"Camera\",\"Photos\"],[\"Settings\",\"AppStore\",\"Clock\",\"Mail\",\"Weather\",\"Wallet\",\"Garage\",\"Home\",\"Maps\",\"Notes\",\"Calculator\",\"VoiceMemo\",\"Music\",\"Services\"]],\"name\":\"lib_e21c\'s Phone\",\"doNotDisturb\":false,\"time\":{\"twelveHourClock\":false},\"sound\":{\"volume\":0.5,\"silent\":false,\"ringtone\":\"default\",\"callVolume\":0.5,\"texttone\":\"default\"},\"security\":{\"pinCode\":false,\"faceId\":false},\"streamerMode\":false,\"wallpaper\":{\"background\":\"cloud8\",\"blur\":false},\"airplaneMode\":false,\"display\":{\"brightness\":1,\"size\":0.7,\"automatic\":false,\"theme\":\"light\"},\"notifications\":[],\"lockscreen\":{\"layout\":1,\"color\":\"gradient\",\"fontStyle\":1},\"weather\":{\"celcius\":false}}',1,0,100,'2026-02-28 23:43:07');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER phone_to_user_identity
AFTER INSERT ON phone_phones
FOR EACH ROW
BEGIN
    UPDATE users
    SET userIdentity = JSON_SET(
        COALESCE(userIdentity, '{}'),
        '$.phone',
        NEW.phone_number
    )
    WHERE id = NEW.owner_id;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER phone_after_insert
AFTER INSERT ON phone_phones
FOR EACH ROW
BEGIN
    UPDATE users
    SET userIdentity = JSON_SET(
        COALESCE(userIdentity, '{}'),
        '$.phone',
        NEW.phone_number
    )
    WHERE gtaLicense;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER phone_after_update
AFTER UPDATE ON phone_phones
FOR EACH ROW
BEGIN
    IF NEW.phone_number <> OLD.phone_number THEN
        UPDATE users
        SET userIdentity = JSON_SET(
            COALESCE(userIdentity, '{}'),
            '$.phone',
            NEW.phone_number
        )
        WHERE gtaLicense;
    END IF;
END */;;
DELIMITER ;

--
-- Table structure for table `phone_photo_album_members`
--

CREATE TABLE `phone_photo_album_members` (
  `album_id` int(11) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`album_id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photo_album_members_ibfk_1` FOREIGN KEY (`album_id`) REFERENCES `phone_photo_albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_photo_album_members_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_photo_album_members`
--


--
-- Table structure for table `phone_photo_album_photos`
--

CREATE TABLE `phone_photo_album_photos` (
  `album_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  PRIMARY KEY (`album_id`,`photo_id`),
  KEY `photo_id` (`photo_id`),
  CONSTRAINT `phone_photo_album_photos_ibfk_1` FOREIGN KEY (`album_id`) REFERENCES `phone_photo_albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_photo_album_photos_ibfk_2` FOREIGN KEY (`photo_id`) REFERENCES `phone_photos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_photo_album_photos`
--


--
-- Table structure for table `phone_photo_albums`
--

CREATE TABLE `phone_photo_albums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(100) NOT NULL,
  `shared` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photo_albums_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_photo_albums`
--


--
-- Table structure for table `phone_photos`
--

CREATE TABLE `phone_photos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `link` varchar(500) NOT NULL,
  `is_video` tinyint(1) DEFAULT 0,
  `size` float NOT NULL DEFAULT 0,
  `metadata` varchar(20) DEFAULT NULL,
  `is_favourite` tinyint(1) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photos_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_photos`
--

INSERT INTO `phone_photos` VALUES (45,'0771819196','https://r2.fivemanage.com/V6qucp8JVzwvO7lBxzfhg/rNHgcUHCOSbd.webp',0,322.37,NULL,0,'2026-03-07 12:42:38'),(46,'0771819196','https://r2.fivemanage.com/V6qucp8JVzwvO7lBxzfhg/35kKzRNNNKQc.webp',0,321.25,NULL,0,'2026-03-07 12:43:23'),(47,'0771819196','https://r2.fivemanage.com/V6qucp8JVzwvO7lBxzfhg/Ue0Hi0H8MzBm.webm',1,3388.94,NULL,0,'2026-03-07 12:48:13');

--
-- Table structure for table `phone_services_channels`
--

CREATE TABLE `phone_services_channels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `company` varchar(50) NOT NULL,
  `last_message` varchar(100) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_services_channels`
--

INSERT INTO `phone_services_channels` VALUES (1,'5208269970','Smurd',NULL,'2025-10-29 06:18:55'),(2,'6029739340','Politie',NULL,'2026-01-06 21:32:59'),(3,'5208269970','Politie',NULL,'2026-01-09 21:30:00'),(4,'0778649855','Politie',NULL,'2026-02-16 13:38:25'),(5,'0783941343','Smurd','aa','2026-02-16 13:39:43'),(6,'0771819196','Politie','aa','2026-03-07 12:14:41');

--
-- Table structure for table `phone_services_messages`
--

CREATE TABLE `phone_services_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `channel_id` int(10) unsigned NOT NULL,
  `sender` varchar(15) NOT NULL,
  `message` varchar(1000) NOT NULL,
  `x_pos` int(11) DEFAULT NULL,
  `y_pos` int(11) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_services_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_services_channels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_services_messages`
--

INSERT INTO `phone_services_messages` VALUES (1,5,'0783941343','aa',299,-244,'2026-02-16 13:39:43'),(2,6,'0771819196','aa',-1054,-1306,'2026-03-07 12:14:41');

--
-- Table structure for table `phone_tiktok_accounts`
--

CREATE TABLE `phone_tiktok_accounts` (
  `name` varchar(30) NOT NULL,
  `bio` varchar(100) DEFAULT NULL,
  `avatar` varchar(500) DEFAULT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  `verified` tinyint(1) DEFAULT 0,
  `follower_count` int(11) NOT NULL DEFAULT 0,
  `following_count` int(11) NOT NULL DEFAULT 0,
  `like_count` int(11) NOT NULL DEFAULT 0,
  `video_count` int(11) NOT NULL DEFAULT 0,
  `twitter` varchar(20) DEFAULT NULL,
  `instagram` varchar(20) DEFAULT NULL,
  `show_likes` tinyint(1) DEFAULT 1,
  `phone_number` varchar(15) NOT NULL,
  `date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_tiktok_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_accounts`
--


--
-- Table structure for table `phone_tiktok_channels`
--

CREATE TABLE `phone_tiktok_channels` (
  `id` varchar(10) NOT NULL,
  `last_message` varchar(50) NOT NULL,
  `member_1` varchar(20) NOT NULL,
  `member_2` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `member_1` (`member_1`,`member_2`),
  KEY `member_2` (`member_2`),
  CONSTRAINT `phone_tiktok_channels_ibfk_1` FOREIGN KEY (`member_1`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_channels_ibfk_2` FOREIGN KEY (`member_2`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_channels`
--


--
-- Table structure for table `phone_tiktok_comments`
--

CREATE TABLE `phone_tiktok_comments` (
  `id` varchar(10) NOT NULL,
  `reply_to` varchar(10) DEFAULT NULL,
  `video_id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `comment` varchar(550) NOT NULL,
  `likes` int(11) NOT NULL DEFAULT 0,
  `replies` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `video_id` (`video_id`),
  KEY `username` (`username`),
  KEY `reply_to` (`reply_to`),
  CONSTRAINT `phone_tiktok_comments_ibfk_1` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_ibfk_3` FOREIGN KEY (`reply_to`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_comments`
--


--
-- Table structure for table `phone_tiktok_comments_likes`
--

CREATE TABLE `phone_tiktok_comments_likes` (
  `username` varchar(20) NOT NULL,
  `comment_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`comment_id`),
  KEY `comment_id` (`comment_id`),
  CONSTRAINT `phone_tiktok_comments_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_likes_ibfk_2` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_comments_likes`
--


--
-- Table structure for table `phone_tiktok_follows`
--

CREATE TABLE `phone_tiktok_follows` (
  `followed` varchar(20) NOT NULL,
  `follower` varchar(20) NOT NULL,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_tiktok_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_follows`
--


--
-- Table structure for table `phone_tiktok_likes`
--

CREATE TABLE `phone_tiktok_likes` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_likes_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_likes`
--


--
-- Table structure for table `phone_tiktok_messages`
--

CREATE TABLE `phone_tiktok_messages` (
  `id` varchar(10) NOT NULL,
  `channel_id` varchar(10) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `content` varchar(500) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  KEY `sender` (`sender`),
  CONSTRAINT `phone_tiktok_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_messages`
--


--
-- Table structure for table `phone_tiktok_notifications`
--

CREATE TABLE `phone_tiktok_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `from` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `video_id` varchar(10) DEFAULT NULL,
  `comment_id` varchar(10) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  KEY `video_id` (`video_id`),
  KEY `comment_id` (`comment_id`),
  CONSTRAINT `phone_tiktok_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_3` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_4` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_notifications`
--


--
-- Table structure for table `phone_tiktok_pinned_videos`
--

CREATE TABLE `phone_tiktok_pinned_videos` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_pinned_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_pinned_videos_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_pinned_videos`
--


--
-- Table structure for table `phone_tiktok_saves`
--

CREATE TABLE `phone_tiktok_saves` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_saves_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_saves_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_saves`
--


--
-- Table structure for table `phone_tiktok_unread_messages`
--

CREATE TABLE `phone_tiktok_unread_messages` (
  `username` varchar(20) NOT NULL,
  `channel_id` varchar(10) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`username`,`channel_id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_tiktok_unread_messages_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_unread_messages_ibfk_2` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_unread_messages`
--


--
-- Table structure for table `phone_tiktok_videos`
--

CREATE TABLE `phone_tiktok_videos` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `src` varchar(500) NOT NULL,
  `caption` varchar(100) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `music` text DEFAULT NULL,
  `likes` int(11) NOT NULL DEFAULT 0,
  `comments` int(11) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  `saves` int(11) NOT NULL DEFAULT 0,
  `pinned_comment` varchar(10) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_tiktok_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_videos`
--


--
-- Table structure for table `phone_tiktok_views`
--

CREATE TABLE `phone_tiktok_views` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_views_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_views_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tiktok_views`
--


--
-- Table structure for table `phone_tinder_accounts`
--

CREATE TABLE `phone_tinder_accounts` (
  `name` varchar(50) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `photos` text DEFAULT NULL,
  `bio` varchar(500) DEFAULT NULL,
  `dob` date NOT NULL,
  `is_male` tinyint(1) NOT NULL,
  `interested_men` tinyint(1) NOT NULL,
  `interested_women` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `last_seen` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`phone_number`),
  CONSTRAINT `phone_tinder_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tinder_accounts`
--


--
-- Table structure for table `phone_tinder_matches`
--

CREATE TABLE `phone_tinder_matches` (
  `phone_number_1` varchar(15) NOT NULL,
  `phone_number_2` varchar(15) NOT NULL,
  `latest_message` varchar(1000) DEFAULT NULL,
  `latest_message_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`phone_number_1`,`phone_number_2`),
  KEY `phone_number_2` (`phone_number_2`),
  CONSTRAINT `phone_tinder_matches_ibfk_1` FOREIGN KEY (`phone_number_1`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_matches_ibfk_2` FOREIGN KEY (`phone_number_2`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tinder_matches`
--


--
-- Table structure for table `phone_tinder_messages`
--

CREATE TABLE `phone_tinder_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(15) NOT NULL,
  `recipient` varchar(15) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_tinder_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tinder_messages`
--


--
-- Table structure for table `phone_tinder_swipes`
--

CREATE TABLE `phone_tinder_swipes` (
  `swiper` varchar(15) NOT NULL,
  `swipee` varchar(15) NOT NULL,
  `liked` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`swiper`,`swipee`),
  KEY `swipee` (`swipee`),
  CONSTRAINT `phone_tinder_swipes_ibfk_1` FOREIGN KEY (`swiper`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_swipes_ibfk_2` FOREIGN KEY (`swipee`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_tinder_swipes`
--


--
-- Table structure for table `phone_twitter_accounts`
--

CREATE TABLE `phone_twitter_accounts` (
  `display_name` varchar(30) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `bio` varchar(100) DEFAULT NULL,
  `profile_image` varchar(500) DEFAULT NULL,
  `profile_header` varchar(500) DEFAULT NULL,
  `pinned_tweet` varchar(50) DEFAULT NULL,
  `verified` tinyint(1) DEFAULT 0,
  `follower_count` int(11) NOT NULL DEFAULT 0,
  `following_count` int(11) NOT NULL DEFAULT 0,
  `private` tinyint(1) DEFAULT 0,
  `date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_twitter_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_accounts`
--


--
-- Table structure for table `phone_twitter_follow_requests`
--

CREATE TABLE `phone_twitter_follow_requests` (
  `requester` varchar(20) NOT NULL,
  `requestee` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`requester`,`requestee`),
  KEY `requestee` (`requestee`),
  CONSTRAINT `phone_twitter_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_follow_requests`
--


--
-- Table structure for table `phone_twitter_follows`
--

CREATE TABLE `phone_twitter_follows` (
  `followed` varchar(20) NOT NULL,
  `follower` varchar(20) NOT NULL,
  `notifications` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_twitter_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_follows`
--


--
-- Table structure for table `phone_twitter_hashtags`
--

CREATE TABLE `phone_twitter_hashtags` (
  `hashtag` varchar(50) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `last_used` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`hashtag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_hashtags`
--


--
-- Table structure for table `phone_twitter_likes`
--

CREATE TABLE `phone_twitter_likes` (
  `tweet_id` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`tweet_id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_likes`
--


--
-- Table structure for table `phone_twitter_messages`
--

CREATE TABLE `phone_twitter_messages` (
  `id` varchar(10) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `recipient` varchar(20) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_twitter_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_messages`
--


--
-- Table structure for table `phone_twitter_notifications`
--

CREATE TABLE `phone_twitter_notifications` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `from` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `tweet_id` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  CONSTRAINT `phone_twitter_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_notifications`
--


--
-- Table structure for table `phone_twitter_promoted`
--

CREATE TABLE `phone_twitter_promoted` (
  `tweet_id` varchar(50) NOT NULL,
  `promotions` int(11) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`tweet_id`),
  CONSTRAINT `phone_twitter_promoted_ibfk_1` FOREIGN KEY (`tweet_id`) REFERENCES `phone_twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_promoted`
--


--
-- Table structure for table `phone_twitter_retweets`
--

CREATE TABLE `phone_twitter_retweets` (
  `tweet_id` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`tweet_id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_retweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_retweets`
--


--
-- Table structure for table `phone_twitter_tweets`
--

CREATE TABLE `phone_twitter_tweets` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `content` varchar(280) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `reply_to` varchar(50) DEFAULT NULL,
  `like_count` int(11) DEFAULT 0,
  `reply_count` int(11) DEFAULT 0,
  `retweet_count` int(11) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_tweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_twitter_tweets`
--


--
-- Table structure for table `phone_voice_memos_recordings`
--

CREATE TABLE `phone_voice_memos_recordings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `file_url` varchar(500) NOT NULL,
  `file_length` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_voice_memos_recordings_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_voice_memos_recordings`
--


--
-- Table structure for table `phone_wallet_transactions`
--

CREATE TABLE `phone_wallet_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `amount` int(11) NOT NULL,
  `company` varchar(50) NOT NULL,
  `logo` varchar(200) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_wallet_transactions_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_wallet_transactions`
--

INSERT INTO `phone_wallet_transactions` VALUES (27,'0707845491',20000,'0771819196',NULL,'2026-03-07 12:12:51'),(28,'0771819196',-20000,'Eric Dev',NULL,'2026-03-07 12:12:51');

--
-- Table structure for table `phone_yellow_pages_posts`
--

CREATE TABLE `phone_yellow_pages_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `attachment` varchar(500) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phone_yellow_pages_posts`
--


--
-- Table structure for table `playerhousing`
--

CREATE TABLE `playerhousing` (
  `id` int(32) NOT NULL,
  `owner` varchar(50) DEFAULT NULL,
  `price` int(32) DEFAULT NULL,
  `wardrobe` text DEFAULT NULL,
  `chest` text DEFAULT NULL,
  `furniture` longtext DEFAULT NULL,
  `garage` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `playerhousing`
--

INSERT INTO `playerhousing` VALUES (72,'2',17000000,NULL,NULL,'[]',NULL);

--
-- Table structure for table `regulamente`
--

CREATE TABLE `regulamente` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `regulamente`
--


--
-- Table structure for table `sdata`
--

CREATE TABLE `sdata` (
  `dkey` varchar(255) NOT NULL,
  `dvalue` text DEFAULT NULL,
  PRIMARY KEY (`dkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sdata`
--


--
-- Table structure for table `turfs`
--

CREATE TABLE `turfs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `radius` int(11) NOT NULL DEFAULT 100,
  `color` int(11) NOT NULL DEFAULT 37,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `turfs`
--


--
-- Table structure for table `udata`
--

CREATE TABLE `udata` (
  `user_id` int(11) NOT NULL,
  `dkey` varchar(255) NOT NULL,
  `dvalue` text DEFAULT NULL,
  PRIMARY KEY (`user_id`,`dkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `udata`
--

INSERT INTO `udata` VALUES (2,'daily_reward_time','1772888314'),(2,'ped:clothes','{\"drawtextures\":[[\"face\",0],[\"masks\",0],[\"hair\",0],[\"torsos\",0],[\"legs\",0],[\"bags\",0],[\"shoes\",0],[\"neck\",0],[\"undershirts\",0],[\"vest\",0],[\"decals\",0],[\"jackets\",0]],\"user_id\":2,\"eyeColor\":0,\"drawables\":{\"1\":[\"masks\",159],\"2\":[\"hair\",0],\"3\":[\"torsos\",0],\"4\":[\"legs\",341],\"5\":[\"bags\",0],\"6\":[\"shoes\",211],\"7\":[\"neck\",0],\"8\":[\"undershirts\",103],\"9\":[\"vest\",64],\"10\":[\"decals\",0],\"11\":[\"jackets\",738],\"0\":[\"face\",0]},\"model\":1885233650,\"props\":{\"1\":[\"glasses\",0],\"2\":[\"earrings\",0],\"3\":[\"mouth\",-1],\"4\":[\"lhand\",-1],\"5\":[\"rhand\",-1],\"6\":[\"watches\",0],\"7\":[\"braclets\",0],\"0\":[\"hats\",161]},\"proptextures\":[[\"hats\",0],[\"glasses\",0],[\"earrings\",0],[\"mouth\",-1],[\"lhand\",-1],[\"rhand\",-1],[\"watches\",0],[\"braclets\",0]]}'),(2,'ped:face','{\"user_id\":2,\"headStructure\":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0],\"headBlend\":{\"thirdMix\":0.0,\"shapeFirst\":3,\"hasParent\":false,\"shapeMix\":0.0,\"skinThird\":0,\"skinSecond\":4,\"skinFirst\":17,\"shapeThird\":0,\"shapeSecond\":2,\"skinMix\":1.0},\"hairColor\":[4,5],\"headOverlay\":[{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"Blemishes\",\"overlayValue\":255},{\"colourType\":1,\"overlayOpacity\":1.0,\"secondColour\":4,\"firstColour\":4,\"name\":\"FacialHair\",\"overlayValue\":2},{\"colourType\":1,\"overlayOpacity\":0.47999998927116,\"secondColour\":4,\"firstColour\":4,\"name\":\"Eyebrows\",\"overlayValue\":1},{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"Ageing\",\"overlayValue\":255},{\"colourType\":2,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"Makeup\",\"overlayValue\":255},{\"colourType\":2,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"Blush\",\"overlayValue\":255},{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"Complexion\",\"overlayValue\":255},{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"SunDamage\",\"overlayValue\":255},{\"colourType\":2,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"Lipstick\",\"overlayValue\":255},{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"MolesFreckles\",\"overlayValue\":255},{\"colourType\":1,\"overlayOpacity\":0.64999997615814,\"secondColour\":3,\"firstColour\":3,\"name\":\"ChestHair\",\"overlayValue\":0},{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"BodyBlemishes\",\"overlayValue\":255},{\"colourType\":0,\"overlayOpacity\":1.0,\"secondColour\":0,\"firstColour\":0,\"name\":\"AddBodyBlemishes\",\"overlayValue\":255}]}'),(2,'ped:Tatoos','[]');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `gtaLicense` varchar(255) DEFAULT NULL,
  `userDiscord` text DEFAULT NULL,
  `lastHours` varchar(255) NOT NULL DEFAULT '0.0',
  `hoursPlayed` varchar(255) NOT NULL DEFAULT '0.0',
  `firstConnect` int(11) DEFAULT NULL,
  `adminLvl` int(11) NOT NULL DEFAULT 0,
  `userBans` text DEFAULT NULL,
  `inventory` text DEFAULT NULL,
  `username` text DEFAULT NULL,
  `last_login` varchar(255) DEFAULT NULL,
  `userIdentity` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`userIdentity`)),
  `userMoney` text DEFAULT NULL,
  `cashMoney` varchar(255) DEFAULT '50000',
  `bankMoney` bigint(20) NOT NULL DEFAULT 0,
  `premiumPoints` varchar(255) DEFAULT NULL,
  `userCoords` text DEFAULT NULL,
  `health` int(11) NOT NULL DEFAULT 200,
  `armour` int(11) NOT NULL DEFAULT 0,
  `userWeapons` text DEFAULT NULL,
  `userLevel` text DEFAULT NULL,
  `userGrades` text DEFAULT NULL,
  `userFaction` text DEFAULT NULL,
  `promotegrades` text DEFAULT NULL,
  `transferExpire` int(255) DEFAULT 0,
  `messagesFront` text DEFAULT NULL,
  `userVip` text DEFAULT NULL,
  `vipLvl` int(11) NOT NULL DEFAULT 0,
  `expireTime` int(11) NOT NULL DEFAULT 0,
  `vipVouchers` text DEFAULT NULL,
  `ajail` int(11) DEFAULT NULL,
  `jailData` text DEFAULT NULL,
  `metroTickets` int(11) DEFAULT NULL,
  `dmvTest` text DEFAULT NULL,
  `dmvCooldown` int(11) NOT NULL DEFAULT 0,
  `investition` text DEFAULT NULL,
  `chatTag` text DEFAULT NULL,
  `userWarns` text DEFAULT NULL,
  `beginnerQuest` text DEFAULT NULL,
  `policeWarrants` text DEFAULT NULL,
  `job` text DEFAULT 'Somer',
  `lastJob` text DEFAULT NULL,
  `adminJails` int(11) NOT NULL DEFAULT 0,
  `easter_progress` int(11) DEFAULT 0,
  `collected_eggs` text DEFAULT '[]',
  `userRaport` int(11) NOT NULL DEFAULT 0,
  `survival` text DEFAULT NULL,
  `weaponState` text DEFAULT NULL,
  `Status` int(11) NOT NULL DEFAULT 0,
  `Nickname` varchar(128) DEFAULT NULL,
  `Password` varchar(128) DEFAULT NULL,
  `Email` varchar(198) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `remember_token` varchar(64) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `deactivated` tinyint(1) NOT NULL DEFAULT 0,
  `bomboanepack` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `panel_nickname` varchar(255) DEFAULT NULL,
  `panel_last_login` datetime DEFAULT NULL,
  `panel_suspend_reason` varchar(129) DEFAULT NULL,
  `panel_code` varchar(64) NOT NULL DEFAULT 'none',
  `panel_email` varchar(255) DEFAULT NULL,
  `panel_suspended` int(11) DEFAULT 0,
  `panel_password` varchar(255) NOT NULL,
  `panel_avatar` varchar(255) DEFAULT NULL,
  `electrocourses` int(11) DEFAULT 0,
  `phone_number` text DEFAULT NULL,
  `all_tickets` int(11) DEFAULT 0,
  `weekly_tickets` int(11) DEFAULT 0,
  `onduty_hours` int(11) DEFAULT 0,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'license:c90e62938e47466bb90eb36303ab0f5f0190f782','discord:801191797846048839','3.8699999999999997','3.8699999999999997',1765060083,13,NULL,'[{\"amount\":1,\"extraData\":[],\"slot\":1,\"description\":\"Carte de identitate unicata\",\"weight\":0.05,\"item\":\"id_doc\",\"label\":\"Buletin\"},{\"amount\":1,\"extraData\":\"Admin Give (ID 1)\",\"slot\":2,\"description\":\"Telefon mobil conectat la reteaua mobila NightLaw\",\"weight\":0.2,\"item\":\"phone\",\"label\":\"Telefon mobil\"}]','BossMountain986','1772321377','{\"iban\": \"NL16423\", \"phone\": \"\", \"firstname\": \"Coxat\", \"sex\": \"M\", \"name\": \"Petronel\", \"age\": 26}',NULL,'69885',190087,'50','{\"z\":29.2967529296875,\"y\":-910.5230712890625,\"x\":-213.53407287597657}',200,100,'[]','{\"need\":60,\"level\":1,\"exp\":22}',NULL,'{\"faction\": \"Politie\", \"rank\": \"Cadet\", \"leader\": 1}','TikToker,YouTuber,ACCES ANTICHEAT,TXADMIN',1769776704,NULL,'{\"vip\":5,\"expireTime\":1774912597}',5,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer','NULL',0,0,'[]',0,'{\"hunger\":27,\"thirst\":33}',NULL,0,NULL,NULL,NULL,'2026-03-07 12:41:40','kQh4Yvhg747igh3E2q9OG48C9BYx0F1C7eI0qcYKzP47BduI3NuM5V2oJJ0p',NULL,0,0,'2026-03-07 12:41:40','BossMountain986','2026-01-03 02:09:12',NULL,'1n2n6','andreidorian17072009@gmail.com',0,'b8dc2a2f4ecbd510869976b0a7a65f01','6953a7acf0172_fondator.png',0,NULL,0,0,0),(2,'license:152cdaa6245e1de95c4489b61f312f15e1b9fd4a','discord:523197539416145920','39.37','39.37',1765813030,12,NULL,'[{\"slot\":1,\"description\":\"Carte de identitate unicata\",\"item\":\"id_doc\",\"extraData\":[],\"label\":\"Buletin\",\"weight\":0.05,\"amount\":1},{\"slot\":2,\"description\":\"Telefon mobil conectat la reteaua mobila NightLaw\",\"item\":\"phone\",\"extraData\":\"Admin Give (ID 2)\",\"label\":\"Telefon mobil\",\"weight\":0.2,\"amount\":1}]','NotAndreiZz','1772985039','{\"name\": \"Ciumpanezu\", \"firstname\": \"Not\", \"phone\": \"0771819196\", \"iban\": \"NL26423\", \"sex\": \"M\", \"age\": 18}',NULL,'109490',426651,'20','{\"z\":29.4483642578125,\"x\":404.4659423828125,\"y\":-927.5076904296875}',130,0,'[{\"attach\":[],\"model\":\"WEAPON_HEAVYPISTOL\",\"tint\":0,\"ammo\":250},{\"attach\":[],\"model\":\"WEAPON_ADVANCEDRIFLE\",\"tint\":0,\"ammo\":242}]','{\"level\":2,\"need\":69,\"exp\":40}',NULL,'{\"faction\": \"Politie\", \"rank\": \"Chestor General\", \"leader\": 1, \"warns\": 0, \"warnExpire\": 0}','TikToker,YouTuber,ACCES ANTICHEAT,TXADMIN',1769779201,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer','NULL',0,0,'[]',0,'{\"thirst\":0,\"hunger\":0}',NULL,0,NULL,NULL,NULL,'2026-03-08 15:54:49','cGiLGDBpLH1OpEzv7ZjWXTi5Slt4neN7jPlzokt7FaY7var5A9hhaO9KearY',NULL,0,0,'2026-03-08 15:54:49','NotAndreiZz','2026-02-19 14:10:45',NULL,'aaaaa','andreipreo22@gmail.com',0,'700848e957d9168318d789e91f5cb6ff','69567110a8238_co-fond (1).png',0,'2059140948',2,2,0),(3,'license:1eaed9bc8ae5624593ea21624d84119261ec1fb3','discord:1005760897815429150','5.84','5.84',1765060316,11,NULL,'[{\"weight\":0.05,\"item\":\"id_doc\",\"label\":\"Buletin\",\"extraData\":[],\"amount\":1,\"slot\":1,\"description\":\"Carte de identitate unicata\"},{\"description\":\"Acest item nu detine o descriere\",\"item\":\"redbull\",\"weight\":0.3,\"extraData\":\"Market (24/7)\",\"currentUsage\":0,\"label\":\"RedBull\",\"amount\":1,\"isUnique\":true,\"slot\":2,\"maxUsage\":100},null,null,null,{\"weight\":0.25,\"item\":\"adrenaline\",\"label\":\"Injectie Adrenalina\",\"amount\":1,\"extraData\":\"Storage (Politie)\",\"slot\":6,\"description\":\"O injectie cu adrenalina.\"}]','lib_e21c','1772323972','{\"phone\": \"0707845491\", \"age\": 21, \"name\": \"Gabriel\", \"iban\": \"NL30816\", \"sex\": \"M\", \"firstname\": \"Eric\"}',NULL,'54920',21510,NULL,'{\"x\":458.0835266113281,\"y\":-1000.2066040039063,\"z\":35.04248046875}',157,0,'[]','{\"level\":1,\"need\":60,\"exp\":6}',NULL,'{\"faction\": \"Politie\", \"rank\": \"Cadet\", \"leader\": 1}','ACCES ANTICHEAT,TXADMIN',0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer','NULL',0,0,'[]',0,'{\"hunger\":0,\"thirst\":0}',NULL,0,NULL,NULL,NULL,'2026-03-07 12:12:51',NULL,NULL,0,0,'2026-03-07 12:12:51',NULL,NULL,NULL,'none',NULL,0,'','69a1f0b2381da_developer.png',0,NULL,0,0,0),(4,'license:1ac78e024a28aa95415f5eba5577537cf96cd482','discord:unknown','0.1','0.1',1767706243,5,NULL,'[{\"extraData\":[],\"item\":\"id_doc\",\"amount\":1,\"label\":\"Buletin\",\"slot\":1,\"description\":\"Carte de identitate unicata\",\"weight\":0.05},{\"extraData\":\"Market (Electronice)\",\"item\":\"phone\",\"amount\":1,\"label\":\"Telefon mobil\",\"slot\":2,\"weight\":0.2,\"description\":\"Telefon mobil conectat la reteaua mobila West\"}]','edi','1767706708','{\"iban\": \"NL40918\", \"name\": \"mocanu\", \"age\": 24, \"firstname\": \"Marius\", \"phone\": \"\", \"sex\": \"M\"}',NULL,'49500',20000,NULL,'{\"y\":-987.6659545898438,\"z\":35.059326171875,\"x\":455.1428527832031}',200,0,'[]','{\"level\":1,\"need\":60,\"exp\":0}',NULL,'{\"faction\": \"Politie\", \"rank\": \"Chestor General\", \"leader\": 1, \"warns\": 0, \"warnExpire\": 0}',NULL,1769775823,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer','NULL',0,0,'[]',0,'{\"hunger\":99,\"thirst\":99}',NULL,0,NULL,NULL,NULL,'2026-01-30 13:40:39',NULL,NULL,0,0,'2026-01-30 13:40:39',NULL,NULL,NULL,'none',NULL,0,'','695e28e7a2fe3_mod2.png',0,NULL,0,0,0),(5,'license:7781e6416bb66d9ca2cef10ade72a934a1ac06d0','discord:692732433480810549','0','0',1768197809,9,NULL,NULL,'[MS-001] Cretu ','1769801773',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,'{\"level\":1,\"need\":60,\"exp\":7}',NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-31 03:01:30',NULL,NULL,0,0,'2026-01-31 03:01:30',NULL,NULL,NULL,'none',NULL,0,'','69664448c8494_admin3.png',0,NULL,0,0,0),(6,'license:b0683d2fae22196e9953534d86e5a32556afaa4b','discord:1342406233864540180','0','0',1769111740,0,NULL,NULL,'barbuocta14','1769111740',NULL,NULL,'50000',10570,NULL,NULL,200,0,NULL,'{\"need\":60,\"exp\":21,\"level\":1}',NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-29 14:09:24',NULL,NULL,0,0,'2026-01-29 14:09:24',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(7,'license:50b0cd0f0b241aa2d4b0a08b7a8c74abeebbdb7e','discord:796760031961677824','0','0',1769520341,0,NULL,NULL,'! Coxme','1769520341',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-29 14:09:21',NULL,NULL,0,0,'2026-01-29 14:09:21',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(8,'license:5718940ef8b5a825e75274b59b5ee7f414a7a458','discord:1390405667298480183','0','0',1769638672,0,NULL,NULL,'BSRP I MONKEY','1769638673',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-29 14:09:14',NULL,NULL,0,0,'2026-01-29 14:09:14',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(9,'license:6ce8868b165a1f0a450f8b3f811aa636ebe55e17','discord:995770852165570600','0','0',1769647988,0,NULL,NULL,'Corleone ','1769647988',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-29 14:09:11',NULL,NULL,0,0,'2026-01-29 14:09:11',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(10,'license:2e77ce803861151bc4f43ce5d413b73763301423','discord:unknown','0','0',1769683511,0,NULL,NULL,'albert nbn','1771249042',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-02-16 14:31:50',NULL,NULL,0,0,'2026-02-16 14:31:50',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(11,'license:e2f89779608607b0c8a4e916ec77ada97c1ab651','discord:unknown','0','0',1769685965,0,NULL,NULL,'Zeneka','1769685965',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-29 14:09:07',NULL,NULL,0,0,'2026-01-29 14:09:07',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(12,'license:62835bd82b178dcdbda85d76fbbcb427880d83d5','discord:unknown','0','0',1769695176,0,NULL,NULL,'Bebe','1769695176',NULL,NULL,'50000',1510,NULL,NULL,200,0,NULL,'{\"level\":1,\"exp\":5,\"need\":60}',NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-29 14:30:09',NULL,NULL,0,0,'2026-01-29 14:30:09',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(13,'license:9b8489581c4ce35d3279aab7d51581eca133e0cb','discord:1092371505213603861','0','0',1769709888,0,NULL,NULL,'[751] Andrei Faget | 135084','1769709888',NULL,NULL,'50000',13590,NULL,NULL,200,0,NULL,'{\"exp\":26,\"level\":1,\"need\":60}',NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-01-30 03:01:18',NULL,NULL,0,0,'2026-01-30 03:01:18',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(14,'license:c3a3e34e564c3090ca989a5ecc2803f0f033e1b6','discord:unknown','0','0',1770557663,0,NULL,NULL,'N1kc0','1770557663',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-02-09 03:01:25',NULL,NULL,0,0,'2026-02-09 03:01:25',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(15,'license:14159f1fe440d54efe4939b4323230ed00c9d461','discord:unknown','0','0',1770558242,0,NULL,NULL,'Teodofius','1770558242',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-03-08 16:05:57',NULL,NULL,0,0,'2026-03-08 16:05:57',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(16,'license:f0bfd471ff2399e5de9f630d626d8a97aeb1604f','discord:1057365626047434802','0','0',1770647120,0,NULL,NULL,'BluntRabbit9463','1770647120',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-02-10 03:01:01',NULL,NULL,0,0,'2026-02-10 03:01:01',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(17,'license:a6450ead9caa792ff2925574128813aa94a1bdd3','discord:1329086276527198289','0','0',1771101599,0,NULL,NULL,'andrei','1771101599',NULL,NULL,'50000',0,NULL,NULL,200,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-02-16 13:01:32',NULL,NULL,0,0,'2026-02-16 13:01:32',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0),(18,'license:e72c13e5b212305bfdbb6995b0bcb25687de1e15','discord:1028937577757147137','0','0',1772252754,0,NULL,NULL,'Alina Popescu','1772252754',NULL,NULL,'50000',28700,NULL,NULL,200,0,NULL,'{\"exp\":4,\"need\":69,\"level\":2}',NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'Somer',NULL,0,0,'[]',0,NULL,NULL,0,NULL,NULL,NULL,'2026-02-28 23:29:37',NULL,NULL,0,0,'2026-02-28 23:29:37',NULL,NULL,NULL,'none',NULL,0,'',NULL,0,NULL,0,0,0);

--
-- Table structure for table `uservehicles`
--

CREATE TABLE `uservehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `vehicle` text DEFAULT NULL,
  `vtype` text DEFAULT NULL,
  `name` text DEFAULT NULL,
  `carPlate` text DEFAULT NULL,
  `state` int(11) NOT NULL DEFAULT 1,
  `vehStatus` text DEFAULT NULL,
  `trunk` text DEFAULT NULL,
  `glovebox` text DEFAULT NULL,
  `premium` int(11) NOT NULL DEFAULT 0,
  `premiumXenon` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `uservehicles`
--

INSERT INTO `uservehicles` VALUES (1,2,'1310s','ds','Dacia 1310 Sport','LS 21SOI',1,NULL,NULL,NULL,0,NULL),(2,2,'mvisiongt','ds','Mercedes-Benz Vision GT V.I.P','LS 75CDZ',2,'{\"condition\":{\"doors\":{\"4\":true,\"3\":true,\"5\":true,\"0\":true,\"2\":true,\"1\":true},\"body_health\":1000.0,\"health\":1000,\"windows\":{\"4\":false,\"3\":false,\"6\":false,\"5\":false,\"0\":false,\"7\":false,\"2\":false,\"1\":false},\"fuel_level\":99,\"km\":7090.2373046875,\"dirt_level\":6.66314888000488,\"petrol_tank_health\":1000.0,\"engine_health\":1000.0,\"tyres\":{\"4\":2,\"3\":2,\"6\":2,\"5\":2,\"0\":2,\"7\":2,\"2\":2,\"1\":2}},\"locked\":false,\"vehData\":{\"engine\":7.5,\"braking\":0.82400000095367},\"customization\":{\"turbo_enabled\":false,\"extra_colours\":[3,0],\"window_tint\":-1,\"culoarer\":26,\"variation\":false,\"culoaresb\":0,\"mods\":{\"17\":-1,\"27\":-1,\"19\":-1,\"29\":-1,\"39\":-1,\"49\":-1,\"37\":-1,\"47\":-1,\"38\":-1,\"48\":-1,\"11\":-1,\"21\":-1,\"31\":-1,\"41\":-1,\"43\":-1,\"35\":-1,\"23\":-1,\"33\":-1,\"28\":-1,\"18\":-1,\"26\":-1,\"22\":-1,\"24\":-1,\"15\":-1,\"32\":-1,\"42\":-1,\"4\":-1,\"3\":-1,\"6\":-1,\"5\":-1,\"0\":-1,\"30\":-1,\"2\":-1,\"1\":-1,\"40\":-1,\"45\":-1,\"20\":-1,\"13\":-1,\"8\":-1,\"7\":-1,\"25\":-1,\"9\":-1,\"14\":-1,\"12\":-1,\"16\":-1,\"10\":-1,\"36\":-1,\"44\":-1,\"34\":-1,\"46\":-1},\"culoaresr\":105,\"smoke_enabled\":false,\"colours\":[118,27],\"tyre_smoke_color\":[255,255,255],\"plate_index\":4,\"extra3\":true,\"extra2\":true,\"culoareb\":33,\"livery\":-1,\"extra1\":true,\"culoaresg\":0,\"wheel_type\":0,\"culoareg\":30}}',NULL,NULL,1,NULL),(3,2,'policeinsurgent','car','Insurgent D.I.I.C.O.T','LS 49PIV',1,'{\"customization\":{\"culoaresr\":179,\"variation\":false,\"tyre_smoke_color\":[255,255,255],\"culoaresb\":201,\"culoareb\":201,\"culoarer\":179,\"window_tint\":-1,\"mods\":{\"40\":-1,\"30\":-1,\"13\":-1,\"20\":-1,\"10\":-1,\"36\":-1,\"45\":-1,\"37\":-1,\"47\":-1,\"27\":-1,\"2\":-1,\"24\":-1,\"32\":-1,\"44\":-1,\"46\":-1,\"7\":-1,\"8\":-1,\"38\":-1,\"31\":-1,\"41\":-1,\"43\":-1,\"9\":-1,\"12\":-1,\"6\":-1,\"14\":-1,\"21\":-1,\"15\":-1,\"4\":-1,\"5\":-1,\"17\":-1,\"3\":-1,\"0\":-1,\"1\":-1,\"11\":-1,\"26\":-1,\"16\":-1,\"48\":-1,\"18\":-1,\"28\":-1,\"22\":-1,\"42\":-1,\"34\":-1,\"25\":-1,\"35\":-1,\"23\":-1,\"33\":-1,\"19\":-1,\"29\":-1,\"39\":-1,\"49\":-1},\"colours\":[112,112],\"culoareg\":185,\"wheel_type\":3,\"livery\":2,\"smoke_enabled\":false,\"plate_index\":4,\"turbo_enabled\":false,\"extra_colours\":[112,0],\"culoaresg\":185},\"locked\":false,\"condition\":{\"dirt_level\":11.02102851867675,\"fuel_level\":100,\"health\":1000,\"petrol_tank_health\":1000.0,\"body_health\":1000.0,\"km\":1192.5609130859376,\"tyres\":{\"2\":2,\"3\":2,\"4\":2,\"5\":2,\"6\":2,\"7\":2,\"0\":2,\"1\":2},\"windows\":{\"2\":1,\"3\":1,\"4\":false,\"5\":false,\"6\":1,\"7\":1,\"0\":1,\"1\":1},\"doors\":{\"2\":true,\"3\":true,\"4\":true,\"5\":true,\"0\":true,\"1\":true},\"engine_health\":1000.0},\"vehData\":{\"braking\":0.60000002384185,\"engine\":2.5}}',NULL,NULL,0,NULL),(4,2,'polamggtr','car','Mercedes AMG GT-R Politie','LS 37JSC',1,'{\"customization\":{\"culoaresr\":8,\"variation\":false,\"tyre_smoke_color\":[255,255,255],\"culoaresb\":8,\"culoareb\":18,\"culoarer\":18,\"window_tint\":-1,\"mods\":{\"40\":-1,\"30\":-1,\"13\":-1,\"20\":-1,\"10\":-1,\"36\":-1,\"45\":-1,\"37\":-1,\"47\":-1,\"27\":-1,\"2\":-1,\"24\":-1,\"32\":-1,\"44\":-1,\"46\":-1,\"7\":-1,\"8\":-1,\"38\":-1,\"31\":-1,\"41\":-1,\"43\":-1,\"9\":-1,\"12\":-1,\"6\":-1,\"14\":-1,\"21\":-1,\"15\":-1,\"4\":-1,\"5\":-1,\"17\":-1,\"3\":-1,\"0\":-1,\"1\":-1,\"11\":-1,\"26\":-1,\"16\":-1,\"48\":-1,\"18\":-1,\"28\":-1,\"22\":-1,\"42\":-1,\"34\":-1,\"25\":-1,\"35\":-1,\"23\":-1,\"33\":-1,\"19\":-1,\"29\":-1,\"39\":-1,\"49\":-1},\"colours\":[16,0],\"culoareg\":18,\"wheel_type\":0,\"livery\":0,\"smoke_enabled\":false,\"plate_index\":4,\"turbo_enabled\":false,\"extra_colours\":[0,0],\"culoaresg\":8},\"locked\":false,\"condition\":{\"dirt_level\":5.01093816757202,\"fuel_level\":100,\"health\":1000,\"petrol_tank_health\":1000.0,\"body_health\":1000.0,\"km\":50.82963943481445,\"tyres\":{\"2\":2,\"3\":2,\"4\":2,\"5\":2,\"6\":2,\"7\":2,\"0\":2,\"1\":2},\"windows\":{\"2\":1,\"3\":1,\"4\":false,\"5\":false,\"6\":1,\"7\":false,\"0\":1,\"1\":1},\"doors\":{\"2\":true,\"3\":true,\"4\":true,\"5\":true,\"0\":true,\"1\":true},\"engine_health\":1000.0},\"vehData\":{\"braking\":0.84799998998641,\"engine\":6.0}}',NULL,NULL,0,NULL);

--
-- Table structure for table `vrp_faction_members`
--

CREATE TABLE `vrp_faction_members` (
  `user_id` int(11) NOT NULL,
  `faction` varchar(50) DEFAULT NULL,
  `rank` int(11) DEFAULT 1,
  `is_leader` tinyint(1) DEFAULT 0,
  `is_coleader` tinyint(1) DEFAULT 0,
  `days` int(11) DEFAULT 0,
  `warns` int(11) DEFAULT 0,
  `last_online` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vrp_faction_members`
--

INSERT INTO `vrp_faction_members` VALUES (2,'Politie',1,1,1,0,0,'2026-01-30 13:45:34');

--
-- Table structure for table `vrp_factions`
--

CREATE TABLE `vrp_factions` (
  `id` int(11) NOT NULL,
  `factionName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `MinLevel` int(11) NOT NULL DEFAULT 5,
  `Application` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_factions`
--

INSERT INTO `vrp_factions` VALUES (1,'Politie',7,1),(2,'Smurd',4,0),(3,'S.I.A.S',5,0),(4,'Mafia Crown',5,0),(5,'Mafia Bratva',4,1),(6,'Mafia Camorra',4,1),(7,'Rue de Lyon',5,0),(8,'Gang MS-16',5,0),(9,'Cartel de Sinaloa',5,0);

--
-- Table structure for table `vrp_garages`
--

CREATE TABLE `vrp_garages` (
  `id` int(255) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `bID` int(11) NOT NULL DEFAULT 0,
  `bColor` int(11) NOT NULL DEFAULT 0,
  `facion` int(11) NOT NULL DEFAULT 0,
  `gtype` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_garages`
--


--
-- Table structure for table `vrp_logs`
--

CREATE TABLE `vrp_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `data` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vrp_logs`
--


--
-- Table structure for table `vrp_money_logs`
--

CREATE TABLE `vrp_money_logs` (
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`from_user_id`,`to_user_id`,`amount`,`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_money_logs`
--


--
-- Table structure for table `vrp_punishlog`
--

CREATE TABLE `vrp_punishlog` (
  `id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `text` text NOT NULL,
  `tip` text DEFAULT NULL,
  `data` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_punishlog`
--


--
-- Table structure for table `vrp_srv_data`
--

CREATE TABLE `vrp_srv_data` (
  `dkey` varchar(255) NOT NULL DEFAULT '',
  `dvalue` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_srv_data`
--


--
-- Table structure for table `vrp_turfs`
--

CREATE TABLE `vrp_turfs` (
  `id` int(255) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `blipColor` int(11) NOT NULL DEFAULT 0,
  `blipRadius` float NOT NULL DEFAULT 110,
  `faction` varchar(50) NOT NULL,
  `isAttacked` varchar(50) NOT NULL DEFAULT 'Nu',
  `attackedBy` varchar(50) NOT NULL DEFAULT 'none',
  `payday` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_turfs`
--


--
-- Table structure for table `vrp_user_business`
--

CREATE TABLE `vrp_user_business` (
  `user_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(30) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `capital` int(11) DEFAULT NULL,
  `laundered` int(11) DEFAULT NULL,
  `reset_timestamp` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_user_business`
--

INSERT INTO `vrp_user_business` VALUES (1,'LSGN','test',NULL,NULL,NULL,1),(3,'LVGN','test1',NULL,NULL,NULL,2);

--
-- Table structure for table `vrp_user_data`
--

CREATE TABLE `vrp_user_data` (
  `user_id` int(11) NOT NULL,
  `dkey` varchar(255) NOT NULL,
  `dvalue` text DEFAULT NULL,
  PRIMARY KEY (`user_id`,`dkey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_user_data`
--


--
-- Table structure for table `vrp_user_homes`
--

CREATE TABLE `vrp_user_homes` (
  `user_id` int(11) NOT NULL DEFAULT 0,
  `home` varchar(255) NOT NULL,
  `number` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_user_homes`
--


--
-- Table structure for table `vrp_user_identities`
--

CREATE TABLE `vrp_user_identities` (
  `user_id` int(11) NOT NULL,
  `registration` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `age` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vrp_user_identities`
--


--
-- Table structure for table `vrp_user_ids`
--

CREATE TABLE `vrp_user_ids` (
  `id` int(255) NOT NULL,
  `identifier` varchar(255) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_user_ids`
--


--
-- Table structure for table `vrp_user_vehicles`
--

CREATE TABLE `vrp_user_vehicles` (
  `id` int(11) NOT NULL,
  `user_id` int(255) NOT NULL,
  `vehicle` varchar(255) NOT NULL,
  `deVanzare` varchar(255) NOT NULL DEFAULT '0',
  `vehicle_type` varchar(255) DEFAULT NULL,
  `vehicle_plate` varchar(255) DEFAULT NULL,
  `upgrades` text DEFAULT NULL,
  `impounded` int(11) NOT NULL DEFAULT 0,
  `veh_type` varchar(255) NOT NULL DEFAULT 'default',
  `ats` text DEFAULT NULL,
  `blocata` int(50) NOT NULL DEFAULT 0,
  `houseNumber` int(10) NOT NULL DEFAULT 0,
  `stage` int(50) DEFAULT 0,
  `storedhouse` varchar(255) DEFAULT '0',
  `garage` int(11) NOT NULL,
  `vehname` int(11) NOT NULL,
  `isFactionCoLeader` int(11) NOT NULL,
  `insurance` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vrp_user_vehicles`
--

INSERT INTO `vrp_user_vehicles` VALUES (1,1,'e36a','0','personal','SV-66-AAA',NULL,0,'default',NULL,0,0,0,'0',0,0,0,0),(2,3,'e36a','0','personal','SV-66-AAA',NULL,0,'default',NULL,0,0,0,'0',0,0,0,0);

--
-- Table structure for table `vrp_users`
--

CREATE TABLE `vrp_users` (
  `id` int(11) NOT NULL,
  `stashData` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vrp_users`
--


--
-- Table structure for table `wc_applications`
--

CREATE TABLE `wc_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `questions` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `faction_id` int(11) NOT NULL DEFAULT 0,
  `faction_name` varchar(128) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `modified_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` varchar(64) DEFAULT NULL,
  `action` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_applications`
--

INSERT INTO `wc_applications` VALUES (1,2,'[\"Nume \\u0219i prenume:\",\"V\\u00e2rsta:\",\"Experien\\u021b\\u0103 anterioar\\u0103 \\u00een RP sau fac\\u021biuni:\",\"De ce vrei s\\u0103 faci parte din Poli\\u021bie?\",\"Ai experien\\u021b\\u0103 \\u00een gestionarea situa\\u021biilor de urgen\\u021b\\u0103 sau conflicte?\",\"Cuno\\u0219ti regulile de circula\\u021bie \\u0219i procedurile legale?\",\"Cum reac\\u021bionezi dac\\u0103 un coleg gre\\u0219e\\u0219te sau abuzeaz\\u0103 de func\\u021bie?\",\"E\\u0219ti dispus s\\u0103 respec\\u021bi ordinele \\u0219i ierarhia fac\\u021biunii?\",\"Ore:\",\"ID:\"]','[\"NotAndreiZz\",\"18\",\"una buna\",\"sa ajut\",\"da\",\"da\",\"da\",\"da\",\"1\",\"2\"]',1,'Politie',1,0,'2025-12-30 11:39:43','2025-12-30 11:39:43',NULL,NULL);

--
-- Table structure for table `wc_comments`
--

CREATE TABLE `wc_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `user_comment` text NOT NULL,
  `topic_id` int(11) NOT NULL DEFAULT 0,
  `topic_category` varchar(64) NOT NULL DEFAULT '-1',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `comment_deleted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_comments`
--

INSERT INTO `wc_comments` VALUES (1,2,'aaaaaaaaaaaaaaaa',1,'complaint','2025-12-11 12:39:09','2025-12-11 12:39:09',0);

--
-- Table structure for table `wc_complaints`
--

CREATE TABLE `wc_complaints` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `user_name` varchar(128) DEFAULT NULL,
  `accused_id` int(11) NOT NULL DEFAULT 0,
  `accused_name` varchar(128) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `category` varchar(64) NOT NULL DEFAULT 'Other',
  `status` int(11) DEFAULT 0,
  `action` varchar(64) DEFAULT NULL,
  `faction_id` int(11) NOT NULL DEFAULT 0,
  `owner` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_complaints`
--

INSERT INTO `wc_complaints` VALUES (1,2,'NotAndreiZz',2,'NotAndreiZz','<p>testtttttttttttttttttttttttttttttt</p>','Player abuse',1,NULL,0,0,'2025-12-11 12:38:47','2025-12-11 12:39:18',NULL);

--
-- Table structure for table `wc_grades`
--

CREATE TABLE `wc_grades` (
  `id` int(11) NOT NULL,
  `grade_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade_level` int(11) NOT NULL DEFAULT 0,
  `grade_category` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_grades`
--

INSERT INTO `wc_grades` VALUES (1,'Helper 1',1,'admin','2023-04-02 08:25:33','2023-04-02 08:32:30'),(2,'Helper 2',2,'admin','2023-04-02 08:25:33','2023-04-02 08:32:36'),(3,'Helper 3',3,'admin','2023-04-02 08:25:33','2023-04-02 08:32:38'),(4,'Moderator 1',4,'admin','2023-04-02 08:25:33','2023-04-02 08:32:44'),(5,'Moderator 2',5,'admin','2023-04-02 08:25:33','2023-04-02 08:32:46'),(6,'Moderator 3',6,'admin','2023-04-02 08:25:33','2023-04-02 08:32:51'),(7,'Admin 1',7,'admin','2023-04-02 08:25:33','2023-04-02 08:32:53'),(8,'Admin 2',8,'admin','2023-04-02 08:25:33','2023-04-02 08:32:56'),(9,'Admin 3',9,'admin','2023-04-02 08:25:33','2023-04-02 08:32:59'),(10,'HeadOffStaff',10,'admin','2023-04-02 08:25:33','2023-04-02 08:29:25'),(11,'Developer',11,'admin','2023-04-02 08:25:33','2023-04-02 08:29:26'),(12,'Co-Fondator',12,'admin','2023-04-02 08:25:33','2023-04-02 08:29:28'),(13,'Fondator',13,'admin','2023-04-02 08:25:33','2023-04-02 08:29:29');

--
-- Table structure for table `wc_logs`
--

CREATE TABLE `wc_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target_id` int(11) NOT NULL DEFAULT -99,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `category` varchar(128) DEFAULT NULL,
  `log` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_logs`
--

INSERT INTO `wc_logs` VALUES (1,-99,2,'4',' <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz [2]</a> has commented on complaint ID #1.','2025-12-11 12:39:09','2025-12-11 12:39:09'),(2,-99,2,'3',' <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz [2]</a> has been updated the Complaint\'s status ID #1 to closed.','2025-12-11 12:39:18','2025-12-11 12:39:18'),(3,-99,2,'4','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a modificat starea tichetului #4 în închis.','2025-12-29 21:12:45','2025-12-29 21:12:45'),(4,-99,2,'4','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a modificat starea tichetului #4 în închis.','2025-12-29 21:13:24','2025-12-29 21:13:24'),(5,-99,2,'4','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a modificat starea tichetului #4 în arhivat.','2025-12-29 21:13:30','2025-12-29 21:13:30'),(6,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: BOGAT contului <a href=\"https://panel.nightlaw.ro/profile/1\">andre</a>.','2025-12-29 21:16:29','2025-12-29 21:16:29'),(7,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: BOSS contului <a href=\"https://panel.nightlaw.ro/profile/1\">andre</a>.','2025-12-29 21:16:50','2025-12-29 21:16:50'),(8,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: BOSS contului <a href=\"https://panel.nightlaw.ro/profile/1\">andre</a>.','2025-12-29 21:17:12','2025-12-29 21:17:12'),(9,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: NOT contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-29 21:33:15','2025-12-29 21:33:15'),(10,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: NOT contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-29 21:33:27','2025-12-29 21:33:27'),(11,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: FRATELE NOSTRU contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2025-12-29 21:37:28','2025-12-29 21:37:28'),(12,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: lib.dev contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2025-12-29 21:37:53','2025-12-29 21:37:53'),(13,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: BOGAT contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 08:50:44','2025-12-30 08:50:44'),(14,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2025-12-30 11:48:52','2025-12-30 11:48:52'),(15,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2025-12-30 11:48:58','2025-12-30 11:48:58'),(16,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2025-12-30 11:49:21','2025-12-30 11:49:21'),(17,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2025-12-30 11:51:06','2025-12-30 11:51:06'),(18,-99,2,'7','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a șters comentariul #2 (#1 application) postat de <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 11:52:26','2025-12-30 11:52:26'),(19,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2025-12-30 12:11:58','2025-12-30 12:11:58'),(20,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2025-12-30 12:21:23','2025-12-30 12:21:23'),(21,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: YOUTUBER contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:11:33','2025-12-30 14:11:33'),(22,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: YOUTUBER contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:14:52','2025-12-30 14:14:52'),(23,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: TIKTOKER contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:15:10','2025-12-30 14:15:10'),(24,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: YOUTUBER contului <a href=\"https://panel.nightlaw.ro/profile/1\">andre</a>.','2025-12-30 14:15:26','2025-12-30 14:15:26'),(25,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: TIKTOKER contului <a href=\"https://panel.nightlaw.ro/profile/1\">andre</a>.','2025-12-30 14:15:37','2025-12-30 14:15:37'),(26,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: TIKTOKER contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:15:54','2025-12-30 14:15:54'),(27,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: TIKTOKER contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:16:15','2025-12-30 14:16:15'),(28,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: WEB-DEV contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:16:37','2025-12-30 14:16:37'),(29,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: Scripter contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2025-12-30 14:17:05','2025-12-30 14:17:05'),(30,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: OWNER contului <a href=\"https://panel.nightlaw.ro/profile/1\">BossMountain986</a>.','2025-12-30 14:20:31','2025-12-30 14:20:31'),(31,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: OWNER contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:20:47','2025-12-30 14:20:47'),(32,1,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: RESPONSABIL DONATII contului <a href=\"https://panel.nightlaw.ro/profile/1\">BossMountain986</a>.','2025-12-30 14:22:04','2025-12-30 14:22:04'),(33,2,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: RESPONSABIL DONATII contului <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a>.','2025-12-30 14:22:20','2025-12-30 14:22:20'),(34,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: BOSS contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2025-12-30 14:26:53','2025-12-30 14:26:53'),(35,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: SUPPORT contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2025-12-30 14:28:23','2025-12-30 14:28:23'),(36,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: Bogat contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2025-12-30 23:06:32','2025-12-30 23:06:32'),(37,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2026-01-01 13:09:30','2026-01-01 13:09:30'),(38,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: TIKTOKER contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2026-01-01 13:11:01','2026-01-01 13:11:01'),(39,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: YOUTUBER contului <a href=\"https://panel.nightlaw.ro/profile/3\">perso</a>.','2026-01-01 13:11:10','2026-01-01 13:11:10'),(40,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2026-01-01 13:28:23','2026-01-01 13:28:23'),(41,4,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: S.I.A.S contului <a href=\"https://panel.nightlaw.ro/profile/4\">edi</a>.','2026-01-07 09:36:22','2026-01-07 09:36:22'),(42,4,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: S.I.A.S contului <a href=\"https://panel.nightlaw.ro/profile/4\">edi</a>.','2026-01-07 09:37:27','2026-01-07 09:37:27'),(43,4,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: STAFF TEAM contului <a href=\"https://panel.nightlaw.ro/profile/4\">edi</a>.','2026-01-07 11:47:01','2026-01-07 11:47:01'),(44,4,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: DIRECTOR S.I.A.S contului <a href=\"https://panel.nightlaw.ro/profile/4\">edi</a>.','2026-01-07 11:48:02','2026-01-07 11:48:02'),(45,4,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: TIKTOKER contului <a href=\"https://panel.nightlaw.ro/profile/4\">edi</a>.','2026-01-07 17:24:48','2026-01-07 17:24:48'),(46,4,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: YOUTUBER contului <a href=\"https://panel.nightlaw.ro/profile/4\">edi</a>.','2026-01-07 17:25:02','2026-01-07 17:25:02'),(47,7,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: Cretu contului <a href=\"https://panel.nightlaw.ro/profile/7\">[MS-001] Cretu </a>.','2026-01-14 08:33:40','2026-01-14 08:33:40'),(48,5,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: DIRECTOR SPITAL contului <a href=\"https://panel.nightlaw.ro/profile/5\">[MS-001] Cretu </a>.','2026-01-25 18:12:40','2026-01-25 18:12:40'),(49,-99,2,'2','<a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a actualizat starea aplicației ID # către delete!','2026-01-27 18:58:25','2026-01-27 18:58:25'),(50,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: ANVELOPER contului <a href=\"https://panel.nightlaw.ro/profile/3\">lib_e21c</a>.','2026-01-30 16:44:15','2026-01-30 16:44:15'),(51,3,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: UI DEVELOPER contului <a href=\"https://panel.nightlaw.ro/profile/3\">lib_e21c</a>.','2026-01-30 16:45:32','2026-01-30 16:45:32'),(52,5,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: [MS-001] contului <a href=\"https://panel.nightlaw.ro/profile/5\">[MS-001] Cretu </a>.','2026-02-13 20:00:44','2026-02-13 20:00:44'),(53,5,2,'1','Adminul <a href=\"https://panel.nightlaw.ro/profile/2\">NotAndreiZz</a> a setat Tag-ul: [MS-001] contului <a href=\"https://panel.nightlaw.ro/profile/5\">[MS-001] Cretu </a>.','2026-02-13 20:01:18','2026-02-13 20:01:18');

--
-- Table structure for table `wc_notifications`
--

CREATE TABLE `wc_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `user_name` varchar(64) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trigger_id` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `seen` int(11) NOT NULL DEFAULT 0,
  `link` varchar(256) NOT NULL DEFAULT '#',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_notifications`
--

INSERT INTO `wc_notifications` VALUES (1,2,NULL,'Unban request #7','New decision has been taken! Check it out!',2,'2025-12-11 12:14:54','2025-12-11 12:14:54',0,'http://panel.nightlaw.ro/unbans/view/7'),(2,2,NULL,'Complaint #1','Your case is having a final decision!',2,'2025-12-11 12:39:18','2025-12-11 12:39:18',0,'http://panel.nightlaw.ro/complaints/view/1'),(3,2,NULL,'Complaint(#1) against you','Your case is having a final decision!',2,'2025-12-11 12:39:18','2025-12-11 12:39:18',0,'http://panel.nightlaw.ro/complaints/view/1'),(4,2,NULL,'Tichet #4','Starea a fost actualizată!',2,'2025-12-29 21:13:24','2025-12-29 21:13:24',1,'https://panel.nightlaw.ro/tickets/view/4'),(5,2,NULL,'Tichet #4','Starea a fost actualizată!',2,'2025-12-29 21:13:30','2025-12-29 21:13:30',1,'https://panel.nightlaw.ro/tickets/view/4');

--
-- Table structure for table `wc_options`
--

CREATE TABLE `wc_options` (
  `id` int(11) NOT NULL,
  `content` text DEFAULT NULL,
  `additional` text DEFAULT NULL,
  `structure` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_options`
--


--
-- Table structure for table `wc_recruitment`
--

CREATE TABLE `wc_recruitment` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT -1,
  `content` text DEFAULT NULL,
  `category` varchar(32) DEFAULT NULL,
  `faction_id` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_recruitment`
--


--
-- Table structure for table `wc_redeem_account`
--

CREATE TABLE `wc_redeem_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(258) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nickname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pending` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `activated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_redeem_account`
--

INSERT INTO `wc_redeem_account` VALUES (1,2,'aaaaa','zEVCLbYQCvi59LlMM4QTH83Dt6pB8qsf3jjFcIEgGn3LrM8MA6Cjn9Gxxeqs','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:42:09','2025-12-29 20:12:13'),(2,2,'aaaaa','I9yxCsD1k2YUUk2AVCNbrqPh1lwkuxzm9zG3Y3k8aGWDNRVV939ZLJEjdHiK','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:43:15','2025-12-29 20:12:13'),(3,2,'aaaaa','E2MuoznVhkayiE28KW73EGfSmIIarXxQ26QwxNyK6pYIKq8chnJotJCNdb0B','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:44:27','2025-12-29 20:12:13'),(4,2,'aaaaa','0hzhE5XwDgeYo8bxpCrl45HzPdQN6BS28UnrI4VHFZ1sJFbad60hd5x390x0','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:44:30','2025-12-29 20:12:13'),(5,2,'aaaaa','1o6qYmjUv7LPVzR30gRx0EhAuYZ9L6u40qZgchEsS07ukC0QtmKoU1xRATrK','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:45:07','2025-12-29 20:12:13'),(6,2,'aaaaa','QK0MxTGExaA6QIMO0AumwETXVzJo7dAamEGE1IBfYls1aA78XSOU3PO5Wddo','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:45:47','2025-12-29 20:12:13'),(7,2,'aaaaa','ctQE47Ihvo16G7GHaaibH1vWZKiYt5LLCkYpbx2sqUZjSziv8sXYys9xr8fC','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:45:49','2025-12-29 20:12:13'),(8,2,'aaaaa','9AGzLinRIzQtJtrdEzRaqnalDBdkazOVOX7Kd3ihHbTh4LWl6RzFkdvRVPm4','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:46:15','2025-12-29 20:12:13'),(9,2,'aaaaa','hEbrTFagEkHwNzaBA6kgexbSlgZUTGZHhvVeVhHRRYGHta4RLiwdeeNh3w9c','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:46:58','2025-12-29 20:12:13'),(10,2,'aaaaa','q4yUu2a6LLEHKbyxpkNt6Siafu0Erlebf5Xh5E6EVOdcynbDjUxhmXr1O236','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:47:10','2025-12-29 20:12:13'),(11,2,'aaaaa','vTemnGlCGB0cA6T1XX159yHzVW8aemGBdQ2KSkGQOPKGQ8oMpbi2ikTTDEAU','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:47:46','2025-12-29 20:12:13'),(12,2,'aaaaa','iS6WduRTuC0NjSOxyWOp94rAz4oFC8P4pSD16CtTIZfGRwqz8sC3ANaVQa7H','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:48:14','2025-12-29 20:12:13'),(13,2,'aaaaa','lPgyVoVNXe1KzhKAoTI7CtWzvCGoeHhAQrl7lT5a387F0pbkY9VOYAsuWoLU','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:48:53','2025-12-29 20:12:13'),(14,2,'aaaaa','7rg3TUrPVT1SkFzBBFZowMfjvkeZcspE8XtLCtXqxUzFxpm1dTIXHVw6ZtTB','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:50:02','2025-12-29 20:12:13'),(15,2,'aaaaa','82PMAGIV4Bp8jIfrTU7LtldYA8SqDNVizx2LoswrC00g7tIcLLq3rlsLUbZs','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:51:10','2025-12-29 20:12:13'),(16,2,'aaaaa','Jth2Dr8TrUKsYD2yTNJDtLf8ZeNkkU3g5SJnRJvBPh6gxvnKt8Hswo7s7n1x','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:51:56','2025-12-29 20:12:13'),(17,2,'aaaaa','cKZNK6HMvjMyIU6PGhkclq33aOQAYiNdvdJKPDgF7JDdmMny3XKfsKjkl8Ez','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:52:12','2025-12-29 20:12:13'),(18,2,'aaaaa','FoD91SOdUCRkJHkTiWo5agRQEb0txhN5sHia3tC1rY39nVW1bvDPsIKYNXG0','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:53:37','2025-12-29 20:12:13'),(19,2,'aaaaa','x0oVV4TJd0ZYM8jX4NTaRBlGmmBN3d1bbxbL81nMaM283F4AnsfLYSD9Lth9','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:54:03','2025-12-29 20:12:13'),(20,2,'aaaaa','NfkSwPEywdo5hBT8W1q3DHXIynumyVq5qANOigDW3CRT5G8R1z7yOplAubFo','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:54:15','2025-12-29 20:12:13'),(21,2,'aaaaa','hq11gPuXxhRbL7bXGXQ005xuTDfCgQ2ZtqEK23XdbqiI646CNOrza65xw2yF','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:54:34','2025-12-29 20:12:13'),(22,2,'aaaaa','UHM0CcXU8IG26ECww2liBhY02NmVwcwE5svieyWV1CNbQYroO7YNJSEXxyq1','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:54:35','2025-12-29 20:12:13'),(23,2,'aaaaa','CpN3UBPgR1kTIVc4t1NKidhtiREpwU1SU0SLesTB3nsonxuOnc0XhpYmDXGm','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:54:36','2025-12-29 20:12:13'),(24,2,'aaaaa','POLeBRN09kizyKg4o6MWpP0L0rdolECWMrqdCosvYyEEzpndQljAibahXMOS','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:55:29','2025-12-29 20:12:13'),(25,2,'aaaaa','Wwu3vcfwf8EmcbbgHzFqJj6HK4rdvSykMhOoB2iaUAWrCXw78HA2G2VOvgYS','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 19:56:06','2025-12-29 20:12:13'),(26,2,'aaaaa','WwScrcOuRLOG7NTt5sOsg3uyPD4X0lZjyBXEu8sO15ab4b1N9lqkKhNNtRG5','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 20:11:47','2025-12-29 20:12:13'),(27,2,'aaaaa','anPpClS6Te3LDlBEvFMmuyBtS6MOo7IoVDhZx59BxptJvoIsr5RPM76L2ju0','andreipreo22@gmail.com','NotAndreiZz','691a8deebd5241a33277c0b4113d5592',1,'2025-12-29 20:13:14','2025-12-29 20:12:13'),(28,1,'1n2n6','RUZ1UaiZwAVm9FdG0Ciw2fMdfw3KOhffpPGZR4PtwlKAYGGM0dpzTkvQmBKL','andreidorian17072009@gmail.com','BossMountain986','b8dc2a2f4ecbd510869976b0a7a65f01',1,'2026-01-03 00:07:48','2026-01-03 00:01:08');

--
-- Table structure for table `wc_settings`
--

CREATE TABLE `wc_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `count` int(11) NOT NULL DEFAULT 0,
  `function` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_settings`
--

INSERT INTO `wc_settings` VALUES (1,0,'Abuz',NULL,'complaint_category','2020-06-27 16:36:37','2023-04-03 11:03:48'),(2,0,'Deathmatch',NULL,'complaint_category','2020-06-27 16:37:34','2023-04-02 09:13:50'),(3,1,'Abuz factiune',NULL,'complaint_category','2020-06-27 16:38:45','2023-04-03 11:03:57'),(4,2,'Abuz admin',NULL,'complaint_category','2020-06-27 17:04:07','2023-04-03 11:04:06'),(5,0,'<span class=\"badge bg-info\">Scazuta</span>',NULL,'ticket_category','2020-06-29 04:32:26','2023-03-21 18:17:29'),(6,1,'<span class=\"badge bg-warning\">Medie</span>',NULL,'ticket_category','2020-06-29 04:32:47','2023-03-21 18:17:45'),(7,2,'<span class=\"badge rounded-pill bg-danger\" style=\"background-color: red !important\">Ridicata</span>',NULL,'ticket_category','2020-06-29 04:32:47','2023-03-21 18:19:42'),(8,0,'<span class=\"badge bg-primary\">Deschis</span>',NULL,'ticket_status','2020-06-29 05:34:59','2023-04-02 07:06:27'),(9,1,'<span class=\"badge bg-dark\">Inchis</span>',NULL,'ticket_status','2020-06-29 05:35:16','2023-04-02 07:07:06'),(10,2,'<span class=\"badge bg-danger\">Arhivat</span>',NULL,'ticket_status','2020-06-30 04:40:17','2023-04-02 07:09:23'),(11,0,'<span class=\"badge bg-primary\">Deschisa</span>',NULL,'complaint_status','2020-07-01 03:08:15','2023-04-02 07:06:15'),(12,1,'<span class=\"badge bg-dark\">Inchisa</span>',NULL,'complaint_status','2020-07-01 03:08:54','2023-04-02 07:07:37'),(13,2,'<span class=\"badge bg-danger\">Arhivata</span>',NULL,'complaint_status','2020-07-01 03:09:21','2023-04-02 07:09:09'),(14,0,'<span class=\"badge bg-primary\">In asteptare</span>',NULL,'unban_status','2020-06-29 05:34:59','2023-04-02 07:07:42'),(15,2,'<span class=\"badge bg-light text-dark\">Respinsa</span>',NULL,'unban_status','2020-06-29 05:35:16','2023-04-02 07:08:00'),(16,1,'<span class=\"badge bg-success\">Acceptata</span>',NULL,'unban_status','2020-06-30 04:40:17','2023-04-02 07:09:15'),(17,3,'<span class=\"badge bg-danger\">Arhivata</span>',NULL,'unban_status','2020-06-30 04:40:17','2023-04-02 07:09:13'),(18,0,'<span class=\"badge bg-primary\">In asteptare</span>',NULL,'application_status','2020-07-04 16:26:00','2023-04-02 07:08:10'),(19,1,'<span class=\"badge bg-warning\">Acceptat pentru teste</span>',NULL,'application_status','2020-07-04 16:26:00','2023-04-02 07:09:18'),(20,2,'<span class=\"badge bg-success\">Acceptat</span>',NULL,'application_status','2020-07-04 16:26:34','2023-04-02 07:09:20'),(21,3,'<span class=\"badge bg-ligh text-dark\">Respins</span>',NULL,'application_status','2020-07-04 16:26:34','2023-04-02 07:08:24'),(22,4,'<span class=\"badge bg-danger\">Arhivat</span>',NULL,'application_status','2020-07-04 16:27:01','2023-04-02 07:09:29'),(23,0,'<span class=\"badge bg-primary\">In asteptare</span>',NULL,'recruitment_status','2020-07-04 16:26:00','2023-04-02 07:08:30'),(24,1,'<span class=\"badge bg-success\">Acceptat</span>',NULL,'recruitment_status','2020-07-04 16:26:34','2023-04-02 07:08:36'),(25,2,'<span class=\"badge bg-light text-dark\">Respins</span>',NULL,'recruitment_status','2020-07-04 16:26:34','2023-04-02 07:08:47'),(26,3,'<span class=\"badge bg-danger\">Arhivat</span>',NULL,'recruitment_status','2020-07-04 16:27:01','2023-04-02 07:08:55'),(27,0,'',NULL,'status_recruitment_admin','2020-08-23 00:29:32','2026-01-03 00:09:48'),(28,0,'',NULL,'status_recruitment_leader','2020-08-23 00:29:32','2025-12-30 11:00:46'),(29,0,'',NULL,'status_recruitment_helper','2020-08-23 00:29:32','2023-04-03 11:24:58'),(30,0,'',NULL,'ip_safety','2020-08-23 00:29:32','2023-03-25 17:25:34'),(31,0,NULL,NULL,'youtube_link_1','2023-03-25 18:49:52','2023-03-25 19:07:56'),(32,0,NULL,NULL,'youtube_cover_1','2023-03-25 18:49:52','2023-03-25 20:01:32'),(33,0,NULL,NULL,'youtube_link_2','2023-03-25 18:51:00','2023-03-25 18:51:00'),(34,0,NULL,NULL,'youtube_cover_2','2023-03-25 18:51:00','2023-03-25 18:51:00'),(35,0,NULL,NULL,'youtube_link_3','2023-03-25 18:51:00','2023-03-25 18:51:00'),(36,0,NULL,NULL,'youtube_cover_3','2023-03-25 18:51:00','2023-03-25 18:51:00'),(37,0,NULL,NULL,'direct_play','2023-03-27 05:11:26','2023-03-27 05:15:42'),(38,0,'',NULL,'discord_channel','2023-03-27 05:11:26','2023-04-03 11:03:25'),(39,0,NULL,'[\"Nume complet (IRL):\",\"V\\u00e2rsta(minim 15):\",\"Nume \\u00een joc (RP):\",\"De ce vrei s\\u0103 faci parte din echipa Staff NightLaw Romania ?\",\"Ce experien\\u021b\\u0103 ai ca membru staff ?\",\"C\\u00e2t timp po\\u021bi aloca zilnic serverului ?\",\"Ce ai face dac\\u0103 un coleg din staff abuzeaz\\u0103 de func\\u021bie ?\",\"Alte men\\u021biuni sau idei pentru \\u00eembun\\u0103t\\u0103\\u021birea serverului:\"]','admin','2023-03-31 12:04:53','2025-12-30 10:55:40'),(40,0,NULL,'[\"Nume complet (IRL):\",\"V\\u00e2rsta(minim 15):\",\"Nume \\u00een joc (RP):\",\"De ce vrei s\\u0103 faci parte din echipa Staff NightLaw Romania ?\",\"Ce experien\\u021b\\u0103 ai ca membru staff ?\",\"C\\u00e2t timp po\\u021bi aloca zilnic serverului ?\",\"Ce ai face dac\\u0103 un coleg din staff abuzeaz\\u0103 de func\\u021bie ?\",\"Alte men\\u021biuni sau idei pentru \\u00eembun\\u0103t\\u0103\\u021birea serverului:\"]','helper','2023-03-31 12:04:53','2025-12-30 10:57:07'),(41,0,NULL,'[\"Nume juc\\u0103tor:\",\"ID:\",\"V\\u00e2rsta:\",\"Ore:\",\"Fac\\u021biunea pentru care aplici ca lider:\",\"Experien\\u021b\\u0103 anterioar\\u0103 \\u00een fac\\u021biuni:\",\"Abilit\\u0103\\u021bi \\u0219i roluri preferate:\",\"Disponibilitate \\/ Ore de joc:\"]','leader','2023-03-31 12:05:00','2025-12-30 11:00:37'),(42,0,'',NULL,'external_shop','2023-04-02 08:51:14','2023-04-03 11:03:13'),(43,0,'',NULL,'complaint_category','2020-06-27 16:36:37','2021-04-02 07:52:44'),(44,0,'',NULL,'complaint_category','2020-06-27 16:37:34','2023-04-02 09:13:50'),(45,0,'',NULL,'complaint_category','2020-06-27 16:36:37','2021-04-02 07:52:44'),(46,0,'',NULL,'complaint_category','2020-06-27 16:37:34','2023-04-02 09:13:50'),(47,2,NULL,'[\"Nume \\u0219i prenume:\",\"V\\u00e2rsta:\",\"Experien\\u021b\\u0103 anterioar\\u0103 \\u00een RP medical sau \\u00een fac\\u021biuni de urgen\\u021b\\u0103:\",\"De ce vrei s\\u0103 faci parte din SMURD?\",\"Ai cuno\\u0219tin\\u021be de prim-ajutor sau experien\\u021b\\u0103 medical\\u0103?\",\"Cum reac\\u021bionezi \\u00eentr-o situa\\u021bie de urgen\\u021b\\u0103 cu mai mul\\u021bi r\\u0103ni\\u021bi?\",\"E\\u0219ti dispus s\\u0103 respec\\u021bi ordinele superiorilor \\u0219i protocoalele medicale?\",\"Ai disponibilitate s\\u0103 intervii rapid \\u00een orice situa\\u021bie de urgen\\u021b\\u0103?\",\"Ore:\",\"ID:\"]','faction','2025-12-29 21:31:01','2025-12-30 11:33:53'),(48,1,NULL,'[\"Nume \\u0219i prenume:\",\"V\\u00e2rsta:\",\"Experien\\u021b\\u0103 anterioar\\u0103 \\u00een RP sau fac\\u021biuni:\",\"De ce vrei s\\u0103 faci parte din Poli\\u021bie?\",\"Ai experien\\u021b\\u0103 \\u00een gestionarea situa\\u021biilor de urgen\\u021b\\u0103 sau conflicte?\",\"Cuno\\u0219ti regulile de circula\\u021bie \\u0219i procedurile legale?\",\"Cum reac\\u021bionezi dac\\u0103 un coleg gre\\u0219e\\u0219te sau abuzeaz\\u0103 de func\\u021bie?\",\"E\\u0219ti dispus s\\u0103 respec\\u021bi ordinele \\u0219i ierarhia fac\\u021biunii?\",\"Ore:\",\"ID:\"]','faction','2025-12-30 11:32:56','2025-12-30 11:32:56');

--
-- Table structure for table `wc_tags`
--

CREATE TABLE `wc_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `user_name` varchar(64) DEFAULT NULL,
  `tag_name` varchar(64) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `color` varchar(16) NOT NULL DEFAULT '#FFFFFF',
  `color_font` varchar(16) NOT NULL DEFAULT '#FFFFFF',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_tags`
--

INSERT INTO `wc_tags` VALUES (1,1,'andre','BOGAT','bi bi-cash-coin','#44ff00','#ffffff','2025-12-29 21:16:29'),(3,1,'andre','BOSS','bi bi-person','#ff0000','#ffffff','2025-12-29 21:17:12'),(5,2,'NotAndreiZz','NOT','bi bi-controller','#ff0000','#ffffff','2025-12-29 21:33:27'),(6,3,'perso','FRATELE NOSTRU','bi bi-star','#ff0000','#ffffff','2025-12-29 21:37:28'),(8,2,'NotAndreiZz','BOGAT','bi bi-cash-coin','#00ff00','#ffffff','2025-12-30 08:50:44'),(10,2,'NotAndreiZz','YOUTUBER','bi bi-camera-reels','#ff0000','#ffffff','2025-12-30 14:14:52'),(12,1,'andre','YOUTUBER','bi bi-camera-reels','#ff0000','#ffffff','2025-12-30 14:15:26'),(13,1,'andre','TIKTOKER','bi bi-camera-reels','#0d0d0d','#ffffff','2025-12-30 14:15:37'),(15,2,'NotAndreiZz','TIKTOKER','bi bi-camera-reels','#050505','#ffffff','2025-12-30 14:16:15'),(16,2,'NotAndreiZz','WEB-DEV','bi bi-code-slash','#1d00fa','#ffffff','2025-12-30 14:16:37'),(17,3,'perso','Scripter','bi bi-code-slash','#0515f0','#ffffff','2025-12-30 14:17:05'),(18,1,'BossMountain986','OWNER','bi bi-star-half','#ff0000','#ffffff','2025-12-30 14:20:31'),(19,2,'NotAndreiZz','OWNER','bi bi-star-half','#ff0000','#ffffff','2025-12-30 14:20:47'),(20,1,'BossMountain986','RESPONSABIL DONATII','bi bi-cash-coin','#00f5e4','#ffffff','2025-12-30 14:22:04'),(21,2,'NotAndreiZz','RESPONSABIL DONATII','bi bi-cash-coin','#00c8f0','#ffffff','2025-12-30 14:22:20'),(24,3,'perso','Bogat','bi bi-cash-coin','#00ff00','#ffffff','2025-12-30 23:06:32'),(25,3,'perso','TIKTOKER','bi bi-camera-reels','#050505','#ffffff','2026-01-01 13:11:01'),(26,3,'perso','YOUTUBER','bi bi-camera-reels','#ff0000','#ffffff','2026-01-01 13:11:10'),(28,4,'edi','S.I.A.S','bi bi-person','#080808','#ffffff','2026-01-07 09:37:27'),(30,4,'edi','DIRECTOR S.I.A.S','bi bi-person','#050505','#ffffff','2026-01-07 11:48:02'),(31,4,'edi','TIKTOKER','bi bi-camera-reels','#f0c800','#ffffff','2026-01-07 17:24:44'),(32,4,'edi','YOUTUBER','bi bi-camera-reels','#ff0000','#ffffff','2026-01-07 17:25:00'),(34,5,'[MS-001] Cretu ','DIRECTOR SPITAL','bi bi-person','#00fa04','#ffffff','2026-01-25 18:12:40'),(36,3,'lib_e21c','UI DEVELOPER','bi bi-star-half','#0400f0','#ffffff','2026-01-30 16:45:32'),(38,5,'[MS-001] Cretu ','[MS-001]','bi bi-person','#ff0000','#ffffff','2026-02-13 20:01:18');

--
-- Table structure for table `wc_tickets`
--

CREATE TABLE `wc_tickets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `priority` tinyint(4) DEFAULT 0,
  `status` tinyint(4) DEFAULT 0,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wc_tickets`
--

INSERT INTO `wc_tickets` VALUES (4,2,'aaaaaaaaaaaaaaaaaaaaaaa','<p>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</p>',2,2,NULL,'2025-12-29 21:12:41','2025-12-29 21:13:30');

--
-- Table structure for table `wc_token`
--

CREATE TABLE `wc_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `email` varchar(256) DEFAULT NULL,
  `token` varchar(128) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deactivated` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_token`
--

INSERT INTO `wc_token` VALUES (1,2,'andreipreo22@gmail.com','tQgWOLYZzT30LzgQ9AiufkUn1LszCdIP10qmWLpPVjkeeoqEUWCjaA4SBJzL','2026-01-01 13:39:32',1),(2,2,'andreipreo22@gmail.com','kCw8agluwrdgAjVQnhzmxhoLYmkvtrNBqFslPJ7ejcy7S4TZYZ4pSdkYJEdl','2026-01-01 13:42:50',1),(3,2,'andreipreo22@gmail.com','lF4iejXZMBvlErUauSt6NOTCnt2gz0MR3kHGhNutM9kgLgK5ShjtxxOdLtpL','2026-01-01 13:43:46',1),(4,2,'andreipreo22@gmail.com','Au61ZMdORekvEjo9c0ZWCufDeGTz7AWyrP7xHJGtj2XAkr1fRWmG2adG9dKs','2026-01-01 13:45:17',1),(5,2,'andreipreo22@gmail.com','mZlV341b3HsKiNb5HvHlBUC00UXqfxPdgsBN0AVtlun87osW13cTxOboVynn','2026-01-01 13:46:39',1),(6,2,'andreipreo22@gmail.com','PLB1Z353zgxbwMov9HcQpLDnNMkLqfnXdXlUQSFrTK9TCCkWItMmJmoRjSrb','2026-01-07 12:23:11',1),(7,2,'andreipreo22@gmail.com','JPekHjBxCoLlVJPdMcDufG74r38GRIhktBQiX6MjebAvYkBz6CRTiq34AQiK','2026-01-23 17:44:27',1),(8,2,'andreipreo22@gmail.com','o4jwnCs1MMuQUGRe46HfPzcKORIv153ezl82dfpksJrCSpRMKdJlwKLwy0O2','2026-01-23 17:44:50',1);

--
-- Table structure for table `wc_unbans`
--

CREATE TABLE `wc_unbans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `user_name` varchar(64) DEFAULT NULL,
  `ban_type` varchar(64) DEFAULT NULL,
  `ban_time` timestamp NULL DEFAULT NULL,
  `ban_details` text DEFAULT NULL,
  `content` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` varchar(64) DEFAULT NULL,
  `action` varchar(256) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_unbans`
--

INSERT INTO `wc_unbans` VALUES (7,2,'NotAndreiZz','Permanent',NULL,'{\"banDate\":1765455240,\"banReason\":\"aa\",\"expire\":0,\"payable\":true,\"bannedBy\":\"Consola\"}','<p>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</p>','2025-12-11 12:14:39','2025-12-11 12:14:54',NULL,'Account unbanned',1);

--
-- Table structure for table `wc_updates`
--

CREATE TABLE `wc_updates` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `update_version` text DEFAULT NULL,
  `update_text` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wc_updates`
--



